title: Parsing SOAP XML in Oracle
body: <p>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.</p>
  
  <p>Could anyone give me an example?</p>
  
  <p>Thanks in advance!!!</p>
  
  <p><strong>edit</strong></p>
  
  <p>It would be a typical SOAP request similar to the one below. </p>
  
  <pre><code>&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"        
                    xmlns:soap="http://soap.service.****.com"&gt; 
    &lt;soapenv:Header /&gt; 
    &lt;soapenv:Body&gt; 
      &lt;soap:UpdateElem&gt; 
        &lt;soap:request&gt; 
          &lt;soap:att1&gt;123456789&lt;/soap:att1&gt; 
          &lt;soap:att2 xsi:nil="true" 
                     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" /&gt;                       
          &lt;soap:att3&gt;L&lt;/soap:att3&gt; 
          ..... 
        &lt;/soap:request&gt; 
      &lt;/soap:UpdateElem&gt;
    &lt;/soapenv:Body&gt; 
  &lt;/soapenv:Envelope&gt;
  </code></pre>
  
  <p>I need to retrieve parameters att1, att2... and save them in to a DB table.</p>