AnsweredAssumed Answered

Passing st_geometry column as argument in pl/sql procedure

Question asked by Czajkowski on Aug 22, 2014
Latest reply on Aug 28, 2014 by fjones-esristaff

Hi   Using  SDE 10.1 in Oracle with ST_Geometry Table..   Am writing  a pl/sql procedure to do a st_intersects of all items of one table against one feature of another.  The procedure takes as arguments the fields of the single feature:

 

create or replace PROCEDURE INTERSECT_WITH_TO_LINKSET_FCS

(

  CLUS IN VARCHAR2,

  FR_LNKS IN VARCHAR2,

  FR_CLLI IN VARCHAR2,

  FR_CABLEID IN VARCHAR2,

  FR_CAB_UNIT_NUM IN VARCHAR2,

  FR_ACLLI IN VARCHAR2,

  FR_ZCLLI IN VARCHAR2,

  FR_SA_ID IN VARCHAR2,

  FR_SHAPE IN SDE.ST_GEOMETRY,

  LINKSET_FC IN VARCHAR2

) AS

 

 

When I try to compile this an error is generated that ST_Geometry must be declared.  It must be some type of permissions thing because ST_Geomtery is the TYPE for the SHAPE field in the featureclass.   Anyone's thoughts would be much appreciated.  I have tried to write "FR_SHAPE" as ST_Geometry, SDE.ST_Gemoetry, etc.  No variations compile.

 

Thanks,

Steve Czajkowski

Outcomes