Attempting to call an ST_Geometry function, such as ST_AsText, results in the following error:
"ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12
ORA-06512: at "SDE.ST_POLYFROMTEXT", line 58"
The Oracle listener is not running or has not been properly configured to use ST_Geometry functions.
Note whether the extproc key is the same in the tnsnames.ora and listener.ora files. See the link in the Related Information section below for specific steps to configure the Oracle listener.