Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SDO_RELATE error ... ORA-13207: incorrect use of the [SDO_RELATE] operator

user20050Oct 13 2006 — edited Oct 16 2006
Just trying to get this query to work. Just got put on this spatial project and simply trying to get this query to work ... ANy ideas?


Thanks in advance


SQL> select a.LAYER_ID,
2 b.FEATURE_DEFINITION_ID,
3 d.OBJECTID,
4 a.LAYER_ID,
5 a.LAYER_NAME,
6 a.AOI_ID
7 from LAYER a,
8 FEATURE_DEFINITION b,
9 FEATURE c,
10 SDO d
11 where a.FEATURE_DEFINITION_ID = b.FEATURE_DEFINITION_ID
12 and d.FEATURE_ID = c.FEATURE_ID
13 and c.LAYER_ID = a.LAYER_ID
14 and a.FEATURE_DEFINITION_ID = 1
15 and sdo_relate(d.SHAPE,
16 SDO_GEOMETRY(2003,
17 null,
18 null,
19 SDO_ELEM_INFO_ARRAY(1,1005,3),
20 SDO_ORDINATE_ARRAY(180,90,180,90)),
21 'masktype = ANYINTERACT querytype = WINDOW') = 'TRUE'
22 /
select a.LAYER_ID,
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [SDO_RELATE] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
ORA-06512: at line 1

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 13 2006
Added on Oct 13 2006
#database-key-features, #spatial
4 comments
4,686 views