How To Avoid DBMS_XMLGEN.GETXML from Returning '<' '>' for SDO_UTIL.TO_GMLGEOMETRY Function
(Doc ID 1563832.1)
Last updated on APRIL 29, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Oracle XML Developers Kit - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Goal
There is the need to generate an XML document for the result of the function SDO_UTIL.TO_GMLGEOMETRY
The dbms_xmlgen.getXml retuns the values for the elements generated for the function's result,
but they are all converted to '<' '>' etc, e.g. -
XML
--------------------------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
<ROW>
<GML_GEOMETRY><gml:Polygon srsName="SDO:" xmlns:gml="http://
www.xx.net/gml"><gml:outerBoundaryIs><gml:LinearRing>&l
t;gml:coordinates decimal="." cs="," ts=" ">5.0
,1.0 8.0,1.0 8.0,6.0 5.0,7.0 5.0,1.0 </gml:coordinates></gml:LinearRing
></gml:outerBoundaryIs></gml:Polygon></GML_GEOMETRY>
</ROW>
</ROWSET>
Is there a way to obtain directly values with '<' '>'?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |