title: How to fix ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
body: <p>In my pl/sql code i have one parameter 'Error' which is used to display the missing values in table.</p>
  
  <pre><code>Error:= '&lt;b&gt;&lt;font color="black"&gt;following values are missing:&lt;/font&gt;&lt;/b&gt;' 
  || val1||val2||val3||val4;
  </code></pre>
  
  <p>Here ErrorText is <code>CLOB</code> datatype and each <code>val1,val2,val3,val4</code> are set to <code>varchar2(2000)</code>.</p>
  
  <p>So, I guess when it is unable to display val_results more than the CLOB limit of 'Error', its throwing </p>
  
  <blockquote>
    <p>ORA-22835.</p>
  </blockquote>
  
  <p>How can I display 'Error' text only upto CLOB limit?</p>