Unable To Add SRID To EPSG Mapping
(Doc ID 2881074.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.12.0.0.0 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |
References |