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 to [Release 11.2]
Oracle XML Developers Kit - Version 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.


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 version="1.0"?>
  <GML_GEOMETRY>&lt;gml:Polygon srsName=&quot;SDO:&quot; xmlns:gml=&quot;http://;&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

Is there a way to obtain directly values with '<' '>'?


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

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