Error: Window SRID does not match layer SRID (Spatial)
626119Jan 7 2010 — edited Jan 7 2010Hi,
I have successfully created an Oracle View with the following SQL:
SELECT * FROM ZKGJI.L1100_CESTE c WHERE SDO_WITHIN_DISTANCE(c.GEOM, SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(425150,95800, 437400,105000)), 'distance=1') = 'TRUE';
When trying to get the preview of the data of the created Oracle View, I am getting following:
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_10I", line 333
The SRID for the fo ZKGJI.L1100_CESTE is '5000000' in Oracle DBMS 11g. How can I set the SRID for the window in the above mentioned SQL?
Dejan