Unable To Add SRID To EPSG Mapping (Doc ID 2881074.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

The query:

SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(90112) FROM DUAL;

returns NULL.

SDO_CS.MAP_ORACLE_SRID_TO_EPSG(90112)

-------------------------------------

After executing:

update sdo_coord_ref_system set legacy_code=28992 where legacy_code is null and srid = 90112;

--The sdo_coord_ref_system table shows that the record has been updated.

1 row updated.

COMMIT;

Commit complete.

Yet, "SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(90112) FROM DUAL;" still returns NULL.

SDO_CS.MAP_ORACLE_SRID_TO_EPSG(90112)

-------------------------------------

Solution

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