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

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

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

 

Example code

 
Result in 11.2.0.2 and 11.2.0.3:

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 10.2.0.4:

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))

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms