AUTH_NAME not saved in MDSYS.CS_SRS when creating user-defined SRID (Doc ID 1365576.1)

Last updated on OCTOBER 10, 2011

Applies to:

Oracle Spatial - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

When creating a user-defined SRID by inserting a row into MDSYS.CS_SRS, the user-supplied AUTH_NAME is not saved.

  INSERT INTO MDSYS.CS_SRS
     (CS_NAME,SRID,AUTH_SRID,AUTH_NAME,WKTEXT)
    VALUES
     ('Netherlands National System - Flexiweb',
      (SELECT MAX(MDSYS.CS_SRS.SRID) +1 FROM MDSYS.CS_SRS),
      (SELECT MAX(MDSYS.CS_SRS.AUTH_SRID) +1 FROM MDSYS.CS_SRS),
     'Isis',
     'PROJCS[...<snip>...'
  );

-- 1 row created.

commit;
-- Commit complete.

select cs_name, srid, auth_name
    from mdsys.cs_srs
    where cs_name = 'Netherlands National System - Flexiweb';

CS_NAME                                        SRID AUTH_NAME
---------------------------------------- ---------- --------------------
Netherlands National System - Flexiweb   1000003006

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