My Oracle Support Banner

How To Avoid DBMS_XMLGEN.GETXML from Returning '&lt' '&gt' 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 '&lt' '&gt' etc, e.g. -

 

XML
--------------------------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <GML_GEOMETRY>&lt;gml:Polygon srsName=&quot;SDO:&quot; xmlns:gml=&quot;http://
www.xx.net/gml&quot;&gt;&lt;gml:outerBoundaryIs&gt;&lt;gml:LinearRing&gt;&l
t;gml:coordinates decimal=&quot;.&quot; cs=&quot;,&quot; ts=&quot; &quot;&gt;5.0
,1.0 8.0,1.0 8.0,6.0 5.0,7.0 5.0,1.0 &lt;/gml:coordinates&gt;&lt;/gml:LinearRing
&gt;&lt;/gml:outerBoundaryIs&gt;&lt;/gml:Polygon&gt;</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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.