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.