title: dbms_output size buffer overflow
body: <p>I tried to set the <code>dbms_output</code> size to unlimited inside a stored procedure.</p>
  
  <p>But it gave me compilation errors.  So I tried in the SQL*Plus prompt the below way. But still I get the buffer overflow error.  How can I overcome this?</p>
  
  <pre><code> set serveroutput on size unlimited;
   exec service_update;
  
  
  ORA-20000: ORU-10027: buffer overflow, limit of 30000 bytes
  ORA-06512: at "SYS.DBMS_OUTPUT", line 32
  ORA-06512: at "SYS.DBMS_OUTPUT", line 97
  ORA-06512: at "SYS.DBMS_OUTPUT", line 112
  ORA-06512: at "ARBOR.SERVICE_UPDATE", line 27
  ORA-06512: at line 1
  </code></pre>