我正试图形成一个使用查询的查询SDO_WITHIN_DISTANCE返回给定矩形内的实体列表。我进行的查询似乎应该可以运行,但是Oracle给了我一些奇怪的错误。这是查询:; S' f) {! N6 ^( k
SELECT * FROM TBLENTITYLOCATION TL INNER JOIN TBLENTITY TE ON TE.ENTITYID=TL.ENTITYID WHERE SDO_WITHIN_DISTANCE (TL.GEOLOCATION SDO_GEOMETRY (2003 NULL NULL SDO_ELEM_INFO_ARRAY(1,1003,3) SDO_ORDINATE_ARRAY(41,-73,36,-82) DISTANCE=10 UNIT=M = 'TRUE' AND TL.LOCATIONDATETIME= (select MAX(LOCATIONDATETIME) FROM TBLENTITYLOCATION WHERE ENTITYID = TE.ENTITYID)错误如下:( N9 i( t H2 T+ a3 x, f, A6 V
ORA-29902: error in executing ODCIIndexStart() routineORA-13208: internal error while evaluating [window SRID does not match layer SRID] operatorORA-06512: at MDSYS.SDO_INDEX_METHOD_10I",line 286OERR说:+ j& H1 p3 d, I) \" p3 B6 c
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.感谢您的帮助或想法。( D$ o' M R/ E# |& d1 o6 G