Error: ORA- < xxxxx > : error in executing ODCIIndexFetch() routine
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.
SQL> SELECT a.pin
FROM parcels a, muni_bnds b
WHERE b.name = 'HYDE PARK'
AND st_intersects(a.shape,b.shape) = 1;
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.