Select using sdo_cs.transform fails with ORA-13282: failure on initialization of coordinate transformation (Doc ID 2236799.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

On : 12.1.0.2 version,

When attempting to run

select sdo_cs.transform(sdo_cs.make_3d(mdsys.sdo_geometry(2001, 20289921, null, mdsys.sdo_elem_info_array(1, 1, 1), mdsys.sdo_ordinate_array(0, 400000))), 20000151) from dual

the following error occurs.

ERROR
-----------------------
select sdo_cs.transform(sdo_cs.make_3d(mdsys.sdo_geometry(2001, 20289921, null, mdsys.sdo_elem_info_array(1, 1, 1), mdsys.sdo_ordinate_array(0, 400000))), 20000151) from dual

-- Output bij Oracle
--SDO_CS.TRANSFORM(SDO_CS.MAKE_3D(MDSYS.SDO_GEOMETRY(2001,20289921,NULL,MDSYS.SDO_
--------------------------------------------------------------------------------
SDO_GEOMETRY(3001, 20000151, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(3.15138659, 51.5675296, 44.1344457))
 
--1 row selected.

-- At Gasunie we get the following error message:
ORA-13282: failure on initialization of coordinate transformation
ORA-06512: at "MDSYS.SDO_CS", line 122
ORA-06512: at "MDSYS.SDO_CS", line 172
ORA-06512: at "MDSYS.SDO_CS", line 5726
ORA-06512: at "MDSYS.SDO_CS", line 3140

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.