Is This Content Helpful?
We're glad to know this article was helpful.
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.
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.