DevOps, CI/CD and Automation

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!

extract array elements from xml soap envelope

104832Apr 14 2004 — edited Jun 1 2004

I have the following xml document saved as an xmltype
<?xml version="1.0" encoding="US-ASCII"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/1999/XMLSchema" xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance">
<soapenv:Body>
<ns1:cleanseAddressResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:dbCleanseSoapBinding">
<ns1:cleanseAddressReturn xsi:type="soapenc:Array" soapenc:arrayType="ns2:string[5]" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns2="http://www.w3.org/2001/XMLSchema">
<item>1369 S 325 E STE 2323</item>
<item/>
<item>BOUNTIFUL</item>
<item>UT</item>
<item>84010</item>
</ns1:cleanseAddressReturn>
</ns1:cleanseAddressResponse>
</soapenv:Body>
</soapenv:Envelope>

Using EXTRACT, how can I get individual values for ITEM? I can't accomplish this in either SQL or PLSQL. I run into ORA-30625 "method dispatch on NULL SELF argument is disallowed" quite a bit.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2004

Added on Apr 14 2004

#general-xml, #xml

1 comment

634 views