Parsing SOAP XML in Oracle
- by user258587
Hi
I am new to Oracle and I am working on something that needs to parse a SOAP request and save the address to DB Tables. I am using the XML parser in Oracle (XMLType) with XPath but am struggling since I can't figure out the way to parse the SOAP request because it has multiple namespaces.
Could anyone give me an example?
Thanks in advance!!!
edit
It would be a typical SOAP request similar to the one below.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soap="http://soap.service.****.com">
<soapenv:Header />
<soapenv:Body>
<soap:UpdateElem>
<soap:request>
<soap:att1>123456789</soap:att1>
<soap:att2 xsi:nil="true"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" />
<soap:att3>L</soap:att3>
.....
</soap:request>
</soap:UpdateElem>
</soapenv:Body>
</soapenv:Envelope>
I need to retrieve parameters att1, att2... and save them in to a DB table.