title: Oracle ORA-22835: Buffer too small for CLOB or BLOB to RAW conversion
body: <p>I am getting error <strong>ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4918, maximum: 4000)</strong> on executing below query (both in hibernate and sql editor).</p>
  
  <pre><code>UPDATE TABLE set COLUMN = UNISTR(COLUMN) WHERE ID = ID;
  </code></pre>
  
  <p><strong>COLUMN</strong> is of type <strong>NCLOB</strong></p>
  
  <p>I have tried to use <strong>TO_CLOB(UNISTR(COLUMN))</strong> and it didn't work for me.</p>
  
  <p>How can I get rid of this?</p>
  
  <p>PN: I am using Oracle 10.x and Hibernate 3.5.x</p>
  
  <p>I have gone through <a href="http://www.dba-oracle.com/t_convert_blob_varchar_datatype.htm" rel="nofollow noreferrer">http://www.dba-oracle.com/t_convert_blob_varchar_datatype.htm</a>. However, I am not able to understand how I can do something similar with UPDATE statement and UNISTR function.</p>