title: Calling Soap wanto ExtractValue from CLOB/ returning null
body: <p>I am new to XML and Clobs. I have read plenty of the posts concerning the subject. I am trying to extract the "processNPCMsgReturn" value from this clob. I am using Oracle 11.2</p>
  
  <p>`</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soap11-enc="http://schemas.xmlsoap.org/soap/encoding/"&gt;
     &lt;env:Header/&gt;
     &lt;env:Body&gt;
        &lt;ws:processNPCMsgResponse env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ws="http://ws.inpac.telcordia.com/"&gt;
           &lt;processNPCMsgReturn&gt;success&lt;/processNPCMsgReturn&gt;
           &lt;processNPCMsgReturn1&gt;success1&lt;/processNPCMsgReturn1&gt;
           &lt;processNPCMsgReturn1&gt;success2&lt;/processNPCMsgReturn2&gt;
        &lt;/ws:processNPCMsgResponse&gt;
     &lt;/env:Body&gt;
  &lt;/env:Envelope&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <pre><code>              -- Create XML type from response text
              l_resp_xml := xmltype.createxml(l_clob_response);
              -- Clean SOAP header
              SELECT extract(l_resp_xml
                            ,'Envelope/Body/node()'
                            ,l_namespace_soap)
                INTO l_resp_xml
                FROM dual;
              -- Extract Fahrenheit value 
              l_result_xml_node := '/processNPCMsgResponse/processNPCMsgReturn/';
              dbms_output.put_line('Response from w3schools webservices:');
              l_result_XML_node := 'processNPCMsgResponse/';
      SELECT EXTRACTVALUE(l_resp_xml, 'processNPCMsgResponse/processNPCMsgReturn', 'xmlns="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ws="http://ws.inpac.telcordia.com/"') INTO l_response_value FROM dual;
  </code></pre>