cannot update sdo_geometry field getting ORA-21700
Running the following query:
declare sdo sdo_geometry
wtms geo_util.wtm_array := GEO_UTIL.WTM_ARRAY();
begin
wtms.extend(3);
wtms(1):='00650205';
wtms(2):='00750409';
wtms(3):='04270000';
update ooi_spatial
set spatial_data_go = GEO_UTIL.MAKE_SDO(wtms)
where ooi_id = '0332-04237CN302';
end;
/
ORA-21700: object does not exist or is marked for delete
OA-06512: at line 8
I can update a non-sdo field without any issues.
All the indexes are valid. All the domain indexes have valid in the domidx_status and domidx_opstatus in dba_indexes.
The MDSYS account is open.
OOI_SPATIAL
----------------------
wtms geo_util.wtm_array := GEO_UTIL.WTM_ARRAY();
begin
wtms.extend(3);
wtms(1):='00650205';
wtms(2):='00750409';
wtms(3):='04270000';
update ooi_spatial
set spatial_data_go = GEO_UTIL.MAKE_SDO(wtms)
where ooi_id = '0332-04237CN302';
end;
/
ORA-21700: object does not exist or is marked for delete
OA-06512: at line 8
I can update a non-sdo field without any issues.
All the indexes are valid. All the domain indexes have valid in the domidx_status and domidx_opstatus in dba_indexes.
The MDSYS account is open.
OOI_SPATIAL
----------------------
0