Hello all,
I´m getting the ORA-13282: failure on initialization of coordinate transformation error when I try to transform coordinates to an user defined SRID on Oracle 11g (SIRGAS 2000 Polyconic - EPSG 5880) .
The commands used to create the datum and the srids are listed below.
<pre>
-- Check if datum and SRIDs exists
select * from mdsys.sdo_datums where datum_id = 6674;
select * from mdsys.sdo_coord_ref_system where srid = 4674;
select * from mdsys.sdo_coord_ref_system where srid = 5880;
-- Create datum EPSG:6674 - SIRGAS 2000.
insert into MDSYS.sdo_datums
(DATUM_ID, DATUM_NAME, DATUM_TYPE, ELLIPSOID_ID, PRIME_MERIDIAN_ID, INFORMATION_SOURCE, DATA_SOURCE,
SHIFT_X, SHIFT_Y, SHIFT_Z, ROTATE_X, ROTATE_Y, ROTATE_Z,SCALE_ADJUST, IS_LEGACY, LEGACY_CODE)
VALUES( 6674, 'Sistema de Referência Geocentrico para las AmericaS 2000', 'GEODETIC', 7019, 8901, 'EPSG - Petrobras', 'EPSG',
0, 0, 0, 0, 0, 0, 0, 'FALSE', NULL);
-- Create SRID EPSG:4674 - SIRGAS 2000
insert into mdsys.sdo_coord_ref_system
(srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id,
datum_id, geog_crs_datum_id, source_geog_srid,projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid,
information_source,data_source, is_legacy, legacy_code, legacy_wktext, legacy_cs_bounds, is_valid, supports_sdo_geometry)
values (4674, 'SIRGAS 2000', 'GEOGRAPHIC2D', 6422,
6674, 6674, null, null, null, null,
'EPSG. See 3D CRS for original information source.', 'OGP', 'FALSE', null, null, null, 'TRUE', 'TRUE');
-- Create SRID EPSG: 5880 - SIRGAS 2000 / Brazil Polyconic MC 54
insert into sdo_coord_ref_system
(srid, coord_ref_sys_name, coord_ref_sys_kind, coord_sys_id,
datum_id, geog_crs_datum_id, source_geog_srid, projection_conv_id, cmpd_horiz_srid, cmpd_vert_srid,
information_source, data_source, is_legacy, legacy_code, legacy_wktext,legacy_cs_bounds,is_valid,supports_sdo_geometry)
values (5880,'SIRGAS 2000 / Brazil Polyconic MC 54','PROJECTED',4499,
null, 6674, 4674, 19941, null,null,
'Petrobras','OGP','FALSE',null,null,null, 'TRUE', 'TRUE');
-- Update WKTs
execute sdo_cs.update_wkts_for_epsg_crs(4674);
execute sdo_cs.update_wkts_for_epsg_crs(5880);
-- Transform a point to SRIDs 4674 and 5880
select sdo_cs.transform(SDO_GEOMETRY(2001,291001,SDO_POINT_TYPE(5000000.0,10000000.0,NULL),NULL,NULL),4674) from dual;
=> Ok
select sdo_cs.transform(SDO_GEOMETRY(2001,291001,SDO_POINT_TYPE(5000000.0,10000000.0,NULL),NULL,NULL),5880) from dual;
=> ORA-13282: failure on initialization of coordinate transformation
</pre>
Any hint on why it´s not working or suggestion on how to transform coordinates to SIRGAS 2000 Polyconic SRID (EPSG 5880)?
Thanks in advance,
Carlos Santos