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:

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

Cause

This is a known issue.

Solution or Workaround