SDO_CS.TRANSFORM Incorrect Result In 10.2.0.5 Upgraded From 10.2.0.4

(Doc ID 1632533.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

The following transformation is giving incorrect results in 10.2.0.5 (Upgraded from 10.2.0.4)

select sdo_cs.transform(sdo_geometry(
2001,
41015,
sdo_point_type(1, 1, null),null,null),
8307)
from dual;


The incorrect result is:

SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-2,9094502, 44,740091, NULL), NULL, NULL)


The correct result in a 10.2.0.4, 11g,12c and 10.2.0.5 where the database was not upgraded from 10.2.0.4 is:

SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(-5.2467635, 44.7400725, NULL), NULL, NULL)

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