Bug
ST_INTERSECTS query produces ORA-29903: error in executing ODCIIndexStart() routine.
| Bug ID Number | NIM062678 |
|---|---|
| Submitted | November 9, 2010 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.0 |
| Operating System | Windows OS |
| Operating System Version | 2003 |
| Version Fixed | N/A |
| Status | Fixed |
Workaround
Swap the ST_INTERSECTS arguments so that the shape argument is on the right and the query will execute although it may take a longer time to return the results. This goes against the KB35498 which outlines that the more selective geometry should be the right argument:http://resources.arcgis.com/content/kbase?fa=articleShow&d=35498Steps to Reproduce
Bug ID: NIM062678
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App