title: Parse SOAP XML in Oracle with example
body: <p>Below is a typical SOAP request in table 'external'.</p>
  
  <pre><code>&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
  &lt;soapenv:Body&gt;
  &lt;settleResponse xmlns="urn:ABC"&gt;
   &lt;settleReturn xmlns=""&gt;
    &lt;message&gt;Missing first name&lt;/message&gt;
    &lt;errorCode&gt;INVALID_ACC&lt;/errorCode&gt;
    &lt;customData&gt;offendingTransactionID=12345678&lt;/customData&gt;
    &lt;divisionRequestID xsi:nil="true"/&gt;
    &lt;status&gt;Failed&lt;/status&gt;
   &lt;/settleReturn&gt;
  &lt;/settleResponse&gt;
  &lt;/soapenv:Body&gt;
  &lt;/soapenv:Envelope&gt;
  </code></pre>
  
  <p>I need to retrieve parameters errorCode, status... and save them in to a DB table. How can I do that?</p>