topic Re: Passing st_geometry column as argument in pl/sql procedure in ArcGIS Enterprise Questions

Passing st_geometry column as argument in pl/sql procedure

StephenCzajkowski — Fri, 22 Aug 2014 12:58:23 GMT

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

Re: Passing st_geometry column as argument in pl/sql procedure

TeroRönkkö — Wed, 27 Aug 2014 09:54:51 GMT

Does it work if you create that pl/sql procedure as SDE user? If it does then it might be type publishing limitation

Re: Passing st_geometry column as argument in pl/sql procedure

ForrestJones — Thu, 28 Aug 2014 17:06:45 GMT

Hi Steve, as Tero suggests, see if it works with the sde user. It could be a privileges issue for the user you are trying to create the procedure with. You should also be able to run describe sde.st_geometry.