Is This Content Helpful?
We're glad to know this article was helpful.
Operations on Oracle Spatial layers cause an underlying database error similar to:
"ORA-13050: unable to construct spatial object
ORA-06512: at "MDSYS.SDO_3GL", line 1731
ORA-06512: at "MDSYS.SDO_3GL", line 1725
ORA-06512: at "MDSYS.SDO_3GL", line 1347"
This error may not be returned to the client directly. The error may be written to the sdedc_Oracle.log file, or the use of an SDEINTERCEPT may be needed to confirm this error. (See the related technical article for a description of how to run an SDEINTERCEPT.)
A nil SDO_Geometry object is being accessed through a filter predicate. This usually happens when a nil geometry is inserted into the Adds table of a versioned feature class.
To correct this error, two actions may have to be taken. Upgrade the ArcGIS software to version 10.2 or later. A PL/SQL procedure also may have to be run to migrate values that are currently stored in the Adds table.
These procedures do not check for permissions on the underlying tables before starting. The geodatabase administrator must have SELECT and UPDATE privileges granted on each table to run the functions successfully.