Forum Stats

  • 3,872,051 Users
  • 2,266,372 Discussions
  • 7,911,041 Comments

Discussions

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

626119
626119 Member Posts: 100
edited Jan 7, 2010 9:25AM in General Database Discussions
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
Tagged:

Answers

  • 626119
    626119 Member Posts: 100
    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';
This discussion has been closed.