Re: Perplexed by PL/SQL error

You either need to increase the amount of space for dbms_output with something like:

dbms_output.enable(1000000);

 or you need to have a pro-c listener program which is constantly emptying the pipe. There is a good example program that comes with Oracle which demonstrates this.

Ken

Juan Carlos wrote:

> I don't have a lot of experience with PL.SQL, but mananged to get the
> following to compile to do a delete from a table containing hundreds of
> thousands of records. The commit level is set artificially low here for
> testing. After running for a bit, it quits with an error shown after to
> code. Does it mean anything to anyone? I see in the doc that DBMS_OUTUPUT
> writes to a buffer in the SGA. Do I need to purge this buffer somehow?
>
> error message follows -------->
> Committed: 10 Total: 670
> Committed: 10 Total: 680
> Committed: 10 Total: 690
> Committed: 10 Total: 700
> Committed: 10 Total: 710
> Committed: 10 Total: 720
> DECLARE
> *
> 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
>
Received on Tue Jul 13 1999 - 07:00:34 CDT