ORA-13293: cannot specify unit for geometry without a georeferenced SRID ORACLE 报错 故障修复 远程处理

文档解释

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错误。