How To Avoid DBMS_XMLGEN.GETXML from Returning '&lt' '&gt' for SDO_UTIL.TO_GMLGEOMETRY Function (Doc ID 1563832.1)

Last updated on FEBRUARY 08, 2017

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
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.opengis.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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms