SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML Parsing & Symbol

252852Oct 29 2009 — edited Oct 30 2009

Hi,
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'?>

<HAR_BILLING_INTERFACE_LN_TG xmlns="Harris.Interop.Oracle.Schemas">

<IDENTIFIER>SHIPPING & HAND</IDENTIFIER>
<IDENTIFIER>SHIPPING & HAND</IDENTIFIER>

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2009

Added on Oct 29 2009

6 comments

885 views