My Oracle Support Banner

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

Last updated on APRIL 08, 2022

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

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
Cause
Solution
References


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