Skip to Main Content

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'?>
<!-- Oracle eXtensible Markup Language Gateway Server -->
<HAR_BILLING_INTERFACE_LN_TG xmlns="Harris.Interop.Oracle.Schemas">


<IDENTIFIER>SHIPPING &amp; HAND</IDENTIFIER>
<IDENTIFIER>SHIPPING & HAND</IDENTIFIER>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2009
Added on Oct 29 2009
6 comments
885 views