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
... View more