Is This Content Helpful?
We're glad to know this article was helpful.
Attempting to call a ST_Geometry function such as ST_AsText results in the following error:
"ERROR at line 1:
ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 170
ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 303"
The Oracle Listener has not been properly configured to use ST_Geometry functions. The FILE_SPEC entry for ST_SHAPELIB as defined in the USER_LIBRARIES or ALL_LIBRARIES data dictionary view is specified incorrectly or not at all in environment variable EXTPROC_DLLS used by the Oracle extproc process.