ORA-13199 from DML on table with Spatial Index after added User Defined Coordinate System SRID
(Doc ID 1098323.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Spatial and Graph - 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 a user defined coordinate system has been created and the following error message is raised when an INSERT statement has been run on a table with a valid Spatial index:
SQL> insert into sites (name, longitude, latitude) values ('te
insert into 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'
insert into 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
A user-defined coordinate systems was added 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;
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |