Spatial Query On A View Fails With An ORA-13226 Error (Doc ID 861754.1)

Last updated on DECEMBER 24, 2013

Applies to:

Oracle Spatial and Graph - Version 10.1.0.1 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 24-Dec-2013

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms