title: PLSQL read value from XML?
body: <p>I have a string with XML code, I want to extract a value from it in PL/SQL to a variable.</p>
  
  <p>The XML is very simple and will not be different than this:</p>
  
  <pre><code>&lt;s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"&gt;
      &lt;s:Body&gt;
          &lt;SOAProxyResponse xmlns="http://tempuri.org/"&gt;
              &lt;SOAProxyResult&gt;
                  There is 23142 Files!
              &lt;/SOAProxyResult&gt;
          &lt;/SOAProxyResponse&gt;
      &lt;/s:Body&gt;
  &lt;/s:Envelope
  </code></pre>
  
  <p>How I can get the value "<strong>There is 23142 Files!</strong>" in the example above into a variable?</p>