SDO_CS.TRANSFORM Incorrect Result In Upgraded From

(Doc ID 1632533.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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


The following transformation is giving incorrect results in (Upgraded from

select sdo_cs.transform(sdo_geometry(
sdo_point_type(1, 1, null),null,null),
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, 11g,12c and where the database was not upgraded from is:

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


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