title: oracle sql - xmltype for extracing xml value not working
body: <p>I have the following xml in my clob field:</p>
  
  <pre><code>&lt;i&gt;7894564&lt;/i&gt;
  &lt;se&gt;ABC&lt;/se&gt;
  </code></pre>
  
  <p>I'm using the following query but it yields to an error:</p>
  
  <pre><code>select xmltype(clob_field).extract('//se/text()').getStringVal() from tablename
  </code></pre>
  
  <p>The error is:</p>
  
  <pre><code>ORA-31011: XML parsing failed
  ORA-19213: error occurred in XML processing at lines 2
  LPX-00245: extra data after end of document
  ORA-06512: at "SYS.XMLTYPE", line 272
  ORA-06512: at line 1
  31011. 00000 -  "XML parsing failed"
  *Cause:    XML parser returned an error while trying to parse the document.
  *Action:   Check if the document to be parsed is valid.
  </code></pre>
  
  <p>Can anyone help me on this? Thanks in advance</p>