ORA-13293: cannot specify unit for geometry without a georeferenced SRID

文档解释

ORA-13293: cannot specify unit for geometry without a georeferenced SRID

Cause: An Oracle Spatial function with a UNIT parameter was called on a geometry without a georeferenced SRID.

Action: Make sure that spatial functions with UNIT parameters are only called on geometries with georeferenced SRIDs.

ORA-13293的错误表明,当在没有基于经纬度和椭球模型的地理参考系统SRID的情况下,无法为几何对象指定单元。

官方解释

常见案例

UPDATE my_table

SET geom_field = SDO_GEOMETRY (‘POINT(1 0)’, 32445)

错误消息:ORA-13293:必须为有地理参考系统(SRID)的几何对象指定单元

正常处理方法及步骤

UPDATE my_table

SET geom_field = SDO_GEOMETRY (‘POINT(1 0)’, 8307)

更新语句中使用了SRID为8307的几何对象,该语句可以正常执行,而不会出现ORA-13293错误。

你可能感兴趣的