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.
Solution or Workaround
Properly configure listener.ora and tnsnames.ora files on the server to use the ST_Geometry library.
Make sure that the path to the ST_SHAPELIB shared library file is specified correctly in the environment variable EXTPROC_DLLS and that this environment variable is available to the Oracle extproc process by defining this environment variable in ORACLE_HOME/network/admin/listener.ora.
See the links in the Related Information section below for specific steps on how to do this.
Refer to the Oracle Database Net Services Administrator's Guide chapter on Enabling Advanced Features of Oracle Net Services for more complete information about configuring the Oracle extproc process.