Passing st_geometry column as argument in pl/sql procedure

[StephenCzajkowski]

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

[TeroRönkkö]

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

[ForrestJones]

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.