INSERT INTO MDSYS.SDO_COORD_REF_SYSTEM RAISES ERRORS (Doc ID 2452308.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

The following insert works in some databases but in another database errors are raised.

SQL> INSERT INTO SDO_COORD_REF_SYSTEM (
  2 SRID,
  3 COORD_REF_SYS_NAME,
  4 COORD_REF_SYS_KIND,
  5 COORD_SYS_ID,
  6 DATUM_ID,
  7 GEOG_CRS_DATUM_ID,
  8 INFORMATION_SOURCE,
  9 DATA_SOURCE,
 10 IS_LEGACY,
 11 IS_VALID,
 12 SUPPORTS_SDO_GEOMETRY)
 13 VALUES (
 14 7843,
 15 'GDA2020',
 16 'GEOGRAPHIC3D',
 17 6423,
 18 1168,
 19 1168,
 20 'Geodesy Section, Geoscience Australia.',
 21 'IOGP',
 22 'FALSE',
 23 'TRUE',
 24 'TRUE');
INSERT INTO SDO_COORD_REF_SYSTEM (
  *
ERROR at line 1:
ORA-24323: value not allowed
ORA-06512: at "MDSYS.MDPRVT_SRID", line 143
ORA-06512: at "MDSYS.SDO_CS", line 1502
ORA-06512: at "MDSYS.SDO_CRS_INSERT_TRIGGER", line 45
ORA-04088: error during execution of trigger 'MDSYS.SDO_CRS_INSERT_TRIGGER'

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.