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

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.