Spatial Query On A View Fails With An ORA-13226 Error
(Doc ID 861754.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Spatial and Graph - Version 10.1.0.1 to 18.104.22.168 [Release 10.1 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 24-Dec-2013
Spatial query on a view fails:
SELECT l.actuallength, l.objectid
FROM imv_lv_ugcable l
WHERE SDO_INSIDE(l.shape,(select c.shape from admb_dist_polygon 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
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