Spatial Query On A View Fails With An ORA-13226 Error
(Doc ID 861754.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Oracle Spatial and Graph - Version 10.1.0.1 and laterInformation in this document applies to any platform.
Symptoms
Spatial query on a view fails:
SELECT l.actuallength, l.objectid
FROM <table1 name> l
WHERE SDO_INSIDE(l.shape,(select c.shape from <table2 name> c where c.objectid = 4)) = 'TRUE';
ERROR at line 1:
ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 1173
ORA-06512: at "MDSYS.SDO_3GL", line 1298
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |