Q: buffer overflow with DBMS_OUTPUT

From: Bernd Becker <bernd.becker_at_ibm.net>
Date: 1997/08/28
Message-ID: <34054243.314223D2@ibm.net>#1/1

I have a problem with buffer overflow when using the DBMS_OUTPUT package.
I want to write data from a database to the screen (STDOUT) in a loop using
DBMS_OUTPUT.PUT_LINE, something like this:

set serveroutput on size 1000000;
LOOP

        FETCH ...
        DBMS_OUTPUT.PUT_LINE('num1='||usr_number1);


        .....

        ....

END LOOP After some number of iterations I get the buffer overflow.

How can I get the buffer to be flushed, for example after each iteration of LOOP?

I have tried this without success:
LOOP

        DBMS_OUTPUT.ENABLE(1000000);
         FETCH ...
        DBMS_OUTPUT.PUT_LINE('num1='||usr_number1);


        .....

        DBMS_OUTPUT.DISABLE;

END LOOP Thanks for any help.

--
Bernd Becker
bernd.becker_at_ibm.net

Received on Thu Aug 28 1997 - 00:00:00 CDT