My Oracle Support Banner

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

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Spatial and Graph - Version 10.1.0.1 and later
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 <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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.