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

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
WHERE b.name = 'HYDE PARK'
AND st_intersects(a.shape,b.shape) = 1;

SELECT a.pin
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.

    Related Information