title: How to update BLOB column in Oracle which contains HTML code
body: <p>I want to update a BLOB column in Oracle DB with HTML. 
  I am using Oracle Oracle Database 11g Release 11.2.0.3.0</p>
  
  <p>The column contains HTML code which would be used in front end in JSP Servlets. The content of cell should be updated with below code</p>
  
  <pre><code>&lt;table width="100%" border="0" cellspacing="0"&gt;
   &lt;tbody&gt;
       &lt;tr&gt;
         &lt;td height="130"&gt;&amp;nbsp;&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
         &lt;td height="130"&gt;&amp;copy; 2013&lt;/td&gt;
       &lt;/tr&gt;
   &lt;/tbody&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>The above code is formatted.The whole thing is single line.Now when I run a update query as below its showing the message </p>
  
  <pre><code>  UPDATE TemplateTbl
       SET TemplateConetent = (RAWTOHEX (UTL_RAW.cast_to_raw ('&lt;table width="100%" border="0" cellspacing="0"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td height="130"&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td height="130"&gt;&amp;copy; 2013&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;')))
     WHERE TemplateId = TL2600
  </code></pre>
  
  <p>Now oracle is asking for variable values because of &copy; and &nbsp; as below</p>
  
  <p><img src="https://i.stack.imgur.com/LwP5Q.png" alt="enter image description here"></p>
  
  <p>I have tried using underscore, Backslash and percentage in front of &amp;copy and &amp;nbsp. But nothing worked. How do I solve this issue?</p>