Dbms_output buffer overflow

Question

I tried to set the size dbms_outputunlimited in the stored procedure.

But that gave me compilation errors. So I tried in the SQL * Plus hint below. But still I get a buffer overflow error. How can I overcome this?

 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

Answer 1

In the service_update procedure, a call accidentally occurs

dbms_output.enable(30000); 

This may cancel the first limit you set.

Answer 2

In Oracle 10gR2, you can also use an unlimited buffer ( https://forums.oracle.com/forums/thread.jspa?threadID=361639 ):

dbms_output.enable(null);