Question

I m 试图用SDO_提出一个问题,即利用SDO公司将一个实体名单归还给某个实体。页: 1 我提出的询问似乎与它一样,但Oracle给我一些奇怪的错误。这里要问:

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)

www.un.org/Depts/DGACM/index_spanish.htm 错误如下:。

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 286

OERR说:

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.

感谢任何帮助或想法。

Answer 1

The ORA-13208 error is the prime one here. The TL.GEOLOCATION needs a matching value in the SRID (second parameter of the SDO_GEOMETRY)

See if the response here 帮助你们。

Answer 2

加里·迈尔斯提供了正确的答案,请允许我补充一下。如果你不了解贵国表格中使用了哪些SRID,那么就会问:

select SRID from USER_SDO_GEOM_METADATA where TABLE_NAME= TBLENTITYLOCATION  and COLUMN_NAME= TBLENTITYLOCATION

另外,为了询问属于试金体内的物体,你不需要SDO_WITHIN_DISTTRA。相反,使用SDO_RELATE,面罩=ANYINTERACT。见。详见下文。

友情链接