Spatial (MOSC)

MOSC Banner

cannot update sdo_geometry field getting ORA-21700

edited Oct 24, 2010 7:08AM in Spatial (MOSC) 2 commentsAnswered
 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
----------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center