ORA-24323: value not allowed When Trying To Add Coordinate Ref Info In Mdsys.cs_srs (Doc ID 2190068.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, Coordinate Systems

When attempting to add a new coordinate system,
the following error occurs.

ERROR
-----------------------
insert into cs_srs (
*
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'
ORA-06512: at "MDSYS.CS_SRS_TRIGGER", line 48
ORA-04088: error during execution of trigger 'MDSYS.CS_SRS_TRIGGER'

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