Transformation problem from Swiss LV95 to WGS84
Hi all,
Using Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
First I try this transformation, from WGS 84 to Swiss coordsys CH1903+ / LV95:
SQL> select mdsys.sdo_cs.transform(SDO_GEOMETRY(3001, 8307, SDO_POINT_TYPE(8.74229514, 47.7506816, null), NULL, NULL),2056) from dual;
which gives the expected result:
SDO_GEOMETRY(3001, 2056, SDO_POINT_TYPE(2697760.97, 1289712.74, NULL), NULL, NULL)
So far so good! (this didn't work on 10.2)
But then I try the reverse transformation:
SQL> select mdsys.sdo_cs.transform(SDO_GEOMETRY(3001, 2056, sdo_point_type(2697760.97, 1289712.74, null), NULL, NULL),8307) from dual;
which gives this result:
SDO_GEOMETRY(3001, 8307, SDO_POINT_TYPE(8.31630928, .637477113, NULL), NULL, NULL)
So the reverse transformation fails - any ideas?