Forum Stats

  • 3,852,639 Users
  • 2,264,126 Discussions
  • 7,905,107 Comments

Discussions

WKT output from oracle 18c differs from that of 11g for compoundcurves

User_NP05Z
User_NP05Z Member Posts: 1 Green Ribbon

We have upgraded from 11g database to 18c database and when running the following query, the output differs:

Query:

SELECT SDO_UTIL.TO_WKTGEOMETRY(SDO_UTIL.RECTIFY_GEOMETRY(SDO_CS.MAKE_2D(MDSYS.SDO_GEOMETRY(3002, 82468, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 4, 2, 1, 2, 1, 4, 2, 1), MDSYS.SDO_ORDINATE_ARRAY(343056.58487, 5814135.22645, 0, 343111.93391, 5814121.44427, 0, 343135.40592, 5814115.6002, 0)), 82468), 0.04)) from dual

Output from 11g:

COMPOUNDCURVE ((343056.58487 5814135.22645, 343111.93391 5814121.44427), (343111.93391 5814121.44427, 343135.40592 5814115.6002))

Output from 18c:

COMPOUNDCURVE (LINESTRING (343056.58487 5814135.22645, 343111.93391 5814121.44427), LINESTRING (343111.93391 5814121.44427, 343135.40592 5814115.6002))

As you can see above, there is an extra LINESTRING in the output from 18c database and it is breaking one of our older applications. I would like to understand if the output from 18c is the standard WKT format and what I can do to change it so that it returns the format similar to 11g?

Thanks,

Tagged:

Answers