1 Reply Latest reply: Nov 12, 2012 5:00 AM by _jum RSS

    SDO_CS.TRANSFORM diffrent results on 10G & 11G

    973504
      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
          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 ?