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