Error: Window SRID does not match layer SRID (Spatial)

626119

Hi,

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

626119

The solution SQL is

SELECT * FROM ZKGJI.L1100_CESTE c WHERE SDO_WITHIN_DISTANCE(c.GEOM, SDO_GEOMETRY(2003, 5000000, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(425150,95800, 437400,105000)), 'distance=1') = 'TRUE';