This is actually a continuation of this question:
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?
" xsi:type="ns2:string" xmlns:ns2="http://www.w3.org/2001/XMLSchema
"><?xml version="1.0" encoding="UTF-8"
amp;I MARSHALL &amp;amp; ILSLEY BANK</BankName>
<BankAddr1>4701 W SCHROEDOR DR</BankAddr1>