title: Bad character escaping when parsing xml from oracle clob
body: <p>I have a simple table like this:</p>
  
  <pre><code>MyTable ( id number(10), configuration CLOB)
  </code></pre>
  
  <p>in oracle 11g (11.2.0.1.0) running on windows.</p>
  
  <p>Now here is my code:</p>
  
  <pre><code>declare
  vconfiguration clob;
  
  vxml xmltype;
  vstring varchar(255);
  begin
      select configuration into vconfiguration from mytable where id=1;
  
      vxml := xmltype(vconfiguration);
  
      dbms_output.put_line(vconfiguration);
  
      vstring := vxml.extract('/SmtpConfiguration/From/text()','xmlns="http://www.blabla.com/Drivers/Smtp"').getStringVal();
      dbms_output.put_line('From=' || vstring);
  end;
  </code></pre>
  
  <p>Here is the output:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;SmtpConfiguration
  xmlns="http://www.blabla.com/Drivers/Smtp"&gt;
  
  &lt;From&gt;"sender1@company.com"&lt;/From&gt;
      &lt;MultiRecipients&gt;TO&lt;/MultiRecipients&gt;
  
  &lt;ServerAddress&gt;smtp_server1&lt;/ServerAddress&gt;
      &lt;ServerPort&gt;25&lt;/ServerPort&gt;
  
  &lt;UseAuthentication&gt;false&lt;/UseAuthentication&gt;
  
  &lt;UseSSL&gt;false&lt;/UseSSL&gt;
  &lt;/SmtpConfiguration&gt;
  
  From=&amp;quot;sender1@company.com&amp;quot;
  </code></pre>
  
  <p>What I want to do is something like <code>insert into anothertable(from) values (vstring);</code></p>
  
  <p>How to get the value of the From tag with proper " instead of &amp; quot ; ?</p>