I have converted our Oracle SDE 10.2.1 database (with service packs, on 11.2.0.3) to ST_GEOMETRY. When I try to use ST_INTERSECTS or ST_WITHIN on featureclasses that have different SRIDs, I instantly get the error that others have gotten as well:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20001: Unable to retrieve message
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 720
ORA-06512: at "SDE.SPX_UTIL", line 761
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 291
If I try to intersect (points in polygons) featureclasses with the same SRID, it works.
I see other threads mentioning that it was fixed in 11.2.0.2 but we are beyond that. What are the other solutions at this point?