I am currently using dbms_output.put_line to debug a pl/sql procedure and got an error "buffer overflow, limit of 2000 bytes".
Could any one tell me how to reset this DBMS_OUTPUT buffer size?
Thanks in advance.
Printable View
I am currently using dbms_output.put_line to debug a pl/sql procedure and got an error "buffer overflow, limit of 2000 bytes".
Could any one tell me how to reset this DBMS_OUTPUT buffer size?
Thanks in advance.
The default and minimum size is 2000. Maximum is 1,000,000. When you set serveroutput on, dbms_output.enable is implicitly called, with the default size of 2000.
SET SERVEROUTPUT ON SIZE n
where n is an integer between 2,000 and 1,000,000.