PROBLEM

SQL functions used with ST_Geometry types stop responding when using shared server processes

Last Published: March 8, 2021

Description

When using SQL functions with ST_Geometry types with Oracle shared server processes, the functions stop responding.

Cause

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, see the links in the Related Information section below.

Article ID:000012228

Software:
  • ArcMap 10 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic