Database Software

Hi,

I am having troubles using the function "SDO_EQUAL". The following query raises an error message:

SELECT SDO_UTIL.TO_WKTGEOMETRY(s.spot_location) from spots s
where SDO_EQUAL(s.spot_location, SDO_GEOMETRY('POINT (-88.5945861592357 42.9480095987261)', 4326)) = 'True';

ORA-29902: error in executing ODCIIndexStart() routine
ORA-13207: incorrect use of the [SDO_EQUAL] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 416
29902. 00000 - "error in executing ODCIIndexStart() routine"
*Cause: The execution of ODCIIndexStart routine caused an error.
*Action: Examine the error messages produced by the indextype code and
take appropriate action.


I think there is nothing wrong about my table, because the following queries work as expected:

SELECT SDO_EQUAL(s.spot_location, SDO_GEOMETRY('POINT (-88.5945861592357 42.9480095987261)', 4326)) from spots s;

SELECT s.spot_location
FROM spots s
WHERE SDO_RELATE(s.spot_location,
SDO_GEOMETRY('POINT (-88.5945861592357 42.9480095987261)', 4326),
'mask=EQUAL') = 'TRUE';


What is wrong about the first query?

Thanks,
Tobias