ORA-13199 from DML on table with Spatial Index after added User Defined Coordinate System SRID (Doc ID 1098323.1)

Last updated on JUNE 08, 2010

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

On 11.1.0.7 we have defined a user defined coordinate system and get following error message when we run a insert statement on the table with a valid Spatial index:

SQL> insert into O2_GSM.sites (name, longitude, latitude) values ('te
insert into O2_GSM.sites (name, longitude, latitude) values ('test2',
*
FEHLER in Zeile 1:
ORA-13199: SRID does not exist.
ORA-06512: in "MDSYS.MD", line 1723
ORA-06512: in "MDSYS.MDERR", line 17
ORA-06512: in "MDSYS.SDO_CS", line 5018
ORA-06512: in "MDSYS.SDO_CS", line 2845
ORA-06512: in "O2_GSM.SP_SITES", line 43
ORA-04088: Error during execution of trigger 'O2_GSM.SP_SITES'



Changes

Added the user-defined coordinate systems through an INSERT into MDSYS.CS_SRS followed by an UPDATE statement on the WKT:

insert into cs_srs (
CS_NAME,
SRID,
AUTH_SRID,
AUTH_NAME,
WKTEXT,
CS_BOUNDS) (
select
CS_NAME,
600003,
AUTH_SRID,
AUTH_NAME,
WKTEXT,
CS_BOUNDS
from
cs_srs
where
srid = 82027);

UPDATE MDSYS.SDO_CS_SRS SET WKTEXT =
'PROJCS["GK Zone 3 (DHDN)",GEOGCS [ "",DATUM ["DHDN", SPHEROID ["Bessel 1841", 6377397.155000, 299.1528128],598.1,73.7,418.2,0.202,0.045,-2.455,6.7],PRIMEM [ "Greenwich", 0.000000 ],UNIT ["Decimal Degree", 0.01745329251994328]],PROJECTION ["Transverse Mercator"],PARAMETER ["Scale_Factor", 1.000000],PARAMETER ["Central_Meridian", 9.000000],PARAMETER ["False_Easting", 3500000.000000],PARAMETER["False_Northing",0.0],UNIT ["Meter", 1.000000000000]]',AUTH_NAME='O2'
WHERE SRID =600003;
commit;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms