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.
- Configuring the Oracle extproc to access the geodatabase with SQL
- Developing Applications with Multiple Programming Languages