This discussion is archived
1 Reply Latest reply: Nov 12, 2012 3:00 AM by _jum RSS

SDO_CS.TRANSFORM diffrent results on 10G & 11G

973504 Newbie
Currently Being Moderated
Hello,

i get diffrent results executing the same transformation on 10G or 11G database. Why?

select SDO_CS.TRANSFORM(
MDSYS.SDO_GEOMETRY(
2001,
4326,
SDO_POINT_TYPE(
7.057038904337076,
52.2122279447782,
NULL),
null,
null
)
,31467
)
from dual;

Result 1: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
(2001; 31467; (3367271,93490396; 5788296,89197313; )

Result 2: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
(2001; 31467; (3954922,19260269; 5832702,16239743; )
  • 1. Re: SDO_CS.TRANSFORM diffrent results on 10G & 11G
    _jum Journeyer
    Currently Being Moderated
    The definitons for coordinate system 4326 differ between ORACLE 10.2.0.5 and ORACLE 11.2.0.3:
    -- ORACLE 10.2.0.5
    SELECT * FROM mdsys.SDO_CS_SRS WHERE srid = 4326;
    
    GEOGCS [ "WGS 84", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137, 298,257223563]],
      PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994328]]
    
    -- ORACLE 11.2.0.3
    SELECT * FROM mdsys.SDO_CS_SRS WHERE srid = 4326;
    
    GEOGCS [ "WGS 84", DATUM ["World Geodetic System 1984 (EPSG ID 6326)", SPHEROID ["WGS 84 (EPSG ID 7030)", 6378137.0, 298.257223563]], 
      PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.0174532925199433]]
    To get consistent results, may be you could use the SRID=8307 instead ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points