EXTPROC setting for ST_GEOM

[yockee]

Hi,

I am having problem in querying using ST_GEOM. I have followed the guideline but without result.

Here is the error i get when i do query "select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;"

I have also modified extproc.ora by adding this line : SET EXTPROC_DLLS=ANY. 

But the result is still the same.

Anybody knows what may be the cause ? How to fix this ?

Thanks

[George_Thompson · Accepted solution]

Run the following SQL as the SDE user:

SELECT file_spec
 FROM user_libraries
 WHERE library_name = 'ST_SHAPELIB';

If the path returned does NOT match your ST_SHAPELIB location, please update it:

CREATE or REPLACE LIBRARY ST_SHAPELIB
 AS '<Location of ST_SHAPELIB file>';

Then:

ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE
 REUSE SETTINGS;

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

This would work if you have already run the Create Enterprise Geodatabase or Create Spatial Type GP tools.

[PamelaLandy]

I have done the procedure for the st_shapelib library. But the query :
select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual
is only correct for me for SDE schema. For other schemes I get error.
What can be caused this ?

[George_Thompson]

If it works in the SDE schema, it is configured properly (as far as I know).

To be honest - I have not run it from another schema.