My Oracle Support Banner

Spatial : Invalid Sdo_geom.transform Results Using LRS Geometries (Doc ID 1544509.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version to [Release 11.2]
Information in this document applies to any platform.


Transforming a LRS geometry using  sdo_cs.transform function from the srid 41013 to the srid 8307 returns
an incorrect result In Oracle Server and
It used to return the correct result in


Example code

select sdo_cs.transform(sdo_geometry(4402,41013,null,sdo_elem_info_array(1,2,1),
sdo_ordinate_array(10000,20000,0,100, 20000,40000,10,200)),8307) from dual;

Result in and

SDO_GEOMETRY(4402, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY (-5.5207577, 47.6044246, 0, 49.3369991, -5.4158359, 47.7925719, 10, 59.2001722))

Result in

SDO_GEOMETRY(4402, 8307, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY( -5.5207577, 47.6044246, 0, 100, -5.4158359, 47.7925719, 10, 200)) 


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

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