ERROR
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.
Code:
begin
SDE.sdo_util.migrate_nil_shapes_to_current(<owner>,<table_name>,<geometry_column>);
end;
Code:
begin
SDE.sdo_util.migrate_nil_shapes_to_current;
end;
Note:
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.
Article ID:000011624
Get help from ArcGIS experts
Download the Esri Support App