Error with : SDO_RELATE(.........) = 'FALSE'
385883Mar 17 2004 — edited Mar 17 2004When i use the operator SDO_RELATE and i try to evaluate it with "= 'FALSE'" or with "!= 'TRUE'" instead of "= 'TRUE'", a receive some errors. The same query works fine when i use "= 'TRUE'",
Is it possible to evaluate the SDO_RELATE operator with "= 'FALSE'" or with "!= 'TRUE'" ?
___________
Example with "= 'FALSE'"
SELECT IDE_TEST
FROM TEST
WHERE (sdo_relate (TEST.GEO_TEST, mdsys.sdo_geometry(2003, 1557057, NULL, mdsys.sdo_elem_info_array(1,1003,1), mdsys.sdo_ordinate_array (994431.1035,519763.6176,995340.97698,518071.25296,995944.125,518928.5,994431.1035,519763.6176)),'mask=anyinteract querytype=WINDOW') = 'FALSE');
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_9I", line 368
ORA-06512: at line 1
_____________
Example with "!= 'TRUE'"
SELECT IDE_TEST
FROM TEST
WHERE (sdo_relate (TEST.GEO_TEST, mdsys.sdo_geometry(2003, 1557057, NULL, mdsys.sdo_elem_info_array(1,1003,1), mdsys.sdo_ordinate_array (994431.1035,519763.6176,995340.97698,518071.25296,995944.125,518928.5,994431.1035,519763.6176)),'mask=anyinteract querytype=WINDOW') != 'TRUE');
ERROR at line 1:
ORA-13268: error obtaining dimension from USER_SDO_GEOM_METADATA
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 89