Re: dbms_output (buffer overflow)

Nick Clark <NickC_at_dial.pipex.com> wrote:
>Chrysalis wrote:
>`
>` Rami Juhela wrote:
>` >
>` > Is there any way to prevent buffer overflow when using
>` > dbms_output.put_line in PL/SQL -cursor loop? (Oracle7).
>` >
>`
>` I presume you are executing your PL/SQL from SQL*Plus.
>` So you need to specify SET SERVEROUT[PUT] ON SIZE nnnnn
>` (Note that the ON is required, even if it is already on!)
>`
>Or you can use
>
>DBMS_OUTPUT.ENABLE(100000);
>
>at the start of your script, which does the same thing ?
>
>Nick.
>--

 I'm already setting the buffer to the maximum possible size and I still get the overflow problem. this occurrs as I'm using DBMS_OUT.PUT_LINE statements in a loop for reporting errors. Unfortunately, if every record I'm processing generates an error I overflow the buffer.

Is there any way to flush or clear the buffer.

Note: DBMS_OUTPUT.DISABLE is supposed to do this. But enabling and disabling DBMS_OUTPUT for every loop interation has not solved the problem.

David Power Received on Tue Mar 04 1997 - 00:00:00 CST