Re: Perplexed by PL/SQL error

In article <7mdu23$m7a$1_at_bgtnsc02.worldnet.att.net>, Juan Carlos <jc_va_at_hotmail.com> writes
>ERROR at line 1:
>ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>ORA-06512: at "SYS.DBMS_OUTPUT", line 106
>ORA-06512: at "SYS.DBMS_OUTPUT", line 65
>ORA-06512: at line 28

All that this means is that the buffer into which all your dbms_output messages are being put overflowed. By default it has a limit of 2000 characters, but can be raised using either:

SQL> set serveroutput on size 100000

or in PL/SQL with:
dbms_output.enable(10000);

Hopefully, you are only using dbms_output for your early debugging work? You might be useful to use something like utl_file to write these messages to a file.

Andy
--
Andy Hardy. PGP key available on request