Adding Custom SRID 1696969 ORA-13276: internal error [SRID 1696969 not found] in coordinate (Doc ID 2937279.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 19.15.0.0.0 version,

ORA-13276: internal error [SRID 1696969 not found.] in coordinate

sqlplus / as sysdba
insert into mdsys.cs_srs values (
'ETRS89 / UTM zone 30N mm',
1696969,
1696969,
null,
'PROJCS["ETRS89 / UTM zone 30N mm",
GEOGCS [ "ETRS89", DATUM ["European Terrestrial Reference System 1989 (EPSG ID 6258)",
SPHEROID ["GRS 1980 (EPSG ID 7019)", 6378137.0, 298.257222101]],
PRIMEM [ "Greenwich", 0.000000 ],
UNIT ["Decimal Degree", 0.0174532925199433]],
PROJECTION ["Transverse Mercator"],
PARAMETER ["Latitude_Of_Origin", 0.0],
PARAMETER ["Central_Meridian", -3.0],
PARAMETER ["Scale_Factor", 0.9996],
PARAMETER ["False_Easting", 500000000.0],
PARAMETER ["False_Northing", -4000000000.0],
UNIT ["Millimeter", 0.001]]',
null,
null);
commit;
exit;

sqlplus another_user/another_user
select sdo_cs.validate_wkt(1696969) from dual;

select sdo_cs.transform(
sdo_geometry(2001,4326,sdo_point_type(3.7038,40.4168,null),null,null), 1696969)
from dual;

-- Should return
--SDO_GEOMETRY(2001, 1696969, SDO_POINT_TYPE(1068947363, 495653005, NULL), NULL, NULL)
 

ERROR
-----------------------
ORA-13276

Changes

Cause

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