Re: Need help with DBMS_OUTPUT in PL/SQL script

In the script "set serveroutput on size 1000000". The default size is 2000 and trhe max size is 1,000,000.

HTH
    James
In article <MPG.1186ce76e4f44949989683_at_news.atl.bellsouth.net>, 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 ??
>
>TIA for all your help.

--

lorenzen_at_yuck.net             | Life is complex; it has
                              |   real and imaginary parts