XML Parsing & Symbol
252852Oct 29 2009 — edited Oct 30 2009Hi,
I am generating some XML Output based on my Query. XML is generated using XML Gateway. Here is the sample..
In my DB column named Identified value is store like "SHIPPING & HAND". 99.9 percent of the time, this value is displayed correctly as can be seen in 2nd Identifier tag but only .0005 percent of the time & is appended with amp; as can be seen. Please let me know what to do so that I can resolve this issue ASAP.
<?xml version = '1.0' encoding = 'ISO-8859-1' standalone = 'no'?>
<!-- Oracle eXtensible Markup Language Gateway Server -->
<HAR_BILLING_INTERFACE_LN_TG xmlns="Harris.Interop.Oracle.Schemas">
<IDENTIFIER>SHIPPING & HAND</IDENTIFIER>
<IDENTIFIER>SHIPPING & HAND</IDENTIFIER>