AnsweredAssumed Answered

ST_Geometry spatial functions and different SRIDs

Question asked by sclark98 on Nov 5, 2014
Latest reply on Nov 17, 2014 by sclark98

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?

Outcomes