Problem: SQL functions used with ST_Geometry types hang when using shared server processes


When using SQL functions with ST_Geometry types with Oracle shared server processes, the function hangs.


This issue may occur because extproc is configured using the extproc.ora file.

Solution or Workaround

Configure extproc through the listener instead. Oracle states that extproc should be configured through the listener for extproc to work properly with shared server processes. For further information on how to configure extproc through the listener, refer to Esri’s ArcGIS Resource Center. See the links in the Related Information section below.

    Related Information