PROBLEM
When using SQL functions with ST_Geometry types with Oracle shared server processes, the functions stop responding.
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, see the links in the Related Information section below.
Get help from ArcGIS experts
Download the Esri Support App