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
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;
sdo_ordinate_array(10000,20000,0,100, 20000,40000,10,200)),8307) from dual;
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
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
| Symptoms |
| Cause |
| Solution |
| References |