[mapserver-users] Oracle Spatial error

[DebasishS at riskinc.com]

Hi,

I am getting the following error when i try to load an oracle spatial
layer.

msOracleSpatialLayerWhichShapes(): OracleSpatial error. ORA-29902: error in
executing ODCIIndexStart() routine ORA-13208: internal error while
evaluating [window SRID does not match layer SRID] operator ORA-06512: at
"MDSYS.SDO_INDEX_METHOD", line 84 ORA-06512: at line 1 . SQL statement:
SELECT rownum, GEOLOC FROM states WHERE SDO_FILTER( GEOLOC,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY
(-228.293276,-60.0032762,-16.6267238,151.663276) ),'querytype=window')
= 'TRUE'

thanks
Debasish.