ORA- < xxxxx > : error in executing ODCIIndexFetch() routine

Last Published: April 25, 2020

Error Message

When executing an ST_Geometry relational operator such as, ST_Intersects, ST_Overlaps, ST_Within, the following error may occur:"ORA-29903: error in executing ODCIIndexFetch() routine""ORA-06532: Subscript outside of limit""ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 455"When the ST_Geometry spatial index is used as the access step for a Structured Query Language (SQL) statement containing an ST_Geometry relational operator, and if more than 32,767 geometries satisfy the predicate argument for the operator being executed, the error is encountered.For example:

FROM parcels a, muni_bnds b
AND st_intersects(a.shape,b.shape) = 1;SELECT
ERROR at line 1:
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-06532: Subscript outside of limit
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 455

In this example, more than 32,767 parcels intersect the muni_bnds shape, and therefore, the error is encountered.


This is a known issue.

Solution or Workaround

To date there is no available workaround. For further assistance please contact ESRI's Support Services.

    Article ID:000009499

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic