title: How to Update Html in clob column
body: <p>I cannot update html content in clob column:</p>
  
  <pre><code>DECLARE
     LONGLITERAL RAW(32767) := UTL_RAW.CAST_TO_RAW(
          '&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
            &lt;head&gt;
            &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8"&gt;
              &lt;title&gt;Promotional email template&lt;/title&gt;
            &lt;/head&gt;
              &lt;body bgcolor="#eeeeee"&gt;
                &lt;!-- Start Header --&gt;
               &lt;/body&gt;
            &lt;/html&gt;');
  BEGIN
    EXECUTE IMMEDIATE
    UPDATE table_name SET gno_clob = :1 WHERE id = 'column_id' USING LONGLITERAL;
  END;
  </code></pre>
  
  <p>I have also tried </p>
  
  <pre><code>EXECUTE IMMEDIATE
    UPDATE table_name SET gno_clob = LONGLITERAL WHERE id = 'column_id';
  END;        
  </code></pre>
  
  <p>Errors</p>
  
  <pre class="lang-none prettyprint-override"><code>    PLS-00103: Encountered the symbol "END" 
      06550. 00000 -  "line %s, column %s:\n%s"
      *Cause:    Usually a PL/SQL compilation error   
  </code></pre>
  
  <ul>
  <li>any suggestion is most welcome.                                                     </li>
  </ul>