troubleshooting Question

XML with Reserved Characters - Take 2

Avatar of Melodi Roberts
Melodi RobertsFlag for United States of America asked on
Oracle DatabaseXML
7 Comments1 Solution410 ViewsLast Modified:
This is actually a continuation of this question:
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/XML/Q_27234034.html

I’d thought I’d solved the problem using extractvalue instead of extract; however, though the results display correctly on the web, an error is thrown with Oracle forms because it still isn’t formatted properly. (e.g.  M&I MARSHALL & ILSLEY BANK)

 I am guessing that the way the web is coded strips out the reserved characters.  

Below is a portion of the XML response that I am attempting to extract the bankName from.

It seems to me that there are too many ‘amp’ strings in this.

If I run extractvalue a twice against the returned XML it works fine.

Is the problem with the XML that the third party is sending me OR is there a chance that I am maybe retrieving the raw XML incorrectly?

  <achValidateRoutingReturn xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance" xsi:type="ns2:string" xmlns:ns2="http://www.w3.org/2001/XMLSchema">&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
&lt;Touchnet&gt;
  &lt;WsResponse InvokedMethod=&quot;achValidateRouting&quot;&gt;
    &lt;Valid&gt;YES&lt;/Valid&gt;
    &lt;BankName&gt;M&amp;amp;amp;I MARSHALL &amp;amp;amp; ILSLEY BANK&lt;/BankName&gt;
    &lt;BankAddr1&gt;4701 W SCHROEDOR DR&lt;/BankAddr1&gt;
    &lt;BankAddr2&gt;MILWAUKEE,WI 53223&lt;/BankAddr2&gt;
  &lt;/WsResponse&gt;
&lt;/Touchnet&gt;
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros