Re: Need help with DBMS_OUTPUT in PL/SQL script

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 21 Apr 1999 21:01:49 GMT
Message-ID: <371d369d.10267589@netnews.worldnet.att.net>

On Tue, 20 Apr 1999 17:49:15 -0600, barry_k_at_bellsouth.net (barry) wrote:

>At the office we are running Oracle 7.2.?.?.? on HP-UX B.10.2 on an
>HP9000. One of my Oracle scripts contains a blockof PL/SQL code in which
>inside a cursor loop I inserted a DBMS_OUTPUT.PUT_LINE() call to display
>debugging information. The problem is that after a few dozen lines I
>received an error message from ORACLE stating that I had exceeded a
>buffer size for DBMS_OUTPUT. Is there any way to increase this buffer
>size ??

Try adding a call to DBMS_OUTPUT.ENABLE to the PL/SQL block. The maximum buffer size is 1,000,000, so maybe you could try the following:

dbms_output.enable (1000000);

Make sure that you insert it prior to the loop.

regards,

Jonathan Received on Wed Apr 21 1999 - 16:01:49 CDT