title: How to increase dbms_output buffer?
body: <p>I tried to debug my dynamic query via <code>dbms_output</code> but seems like the query string is too long for <code>dbms_output</code> buffer. </p>
  
  <p>I got :</p>
  
  <pre><code>ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at "SYS.DBMS_OUTPUT", line 148
  ORA-06512: at line 1 
  </code></pre>
  
  <p>Any idea how to increase the buffer size ?</p>