Re: What's wrong with DBMS_OUTPUT.PUT_LINE buffer overflow?

Use "set serveroutput on size 1000000". This will help, but the buffer is not flushed until the outer block is completed. This is a problem with DBMS_OUTPUT. The size of 1,000,000 is the maximum size for the serverputput parameter.

HTH
   James

In article <6q7akt$4oh$1_at_news.gns.getronics.nl>, "Internet Nieuwsserver" <flesterh_at_gak.nl> wrote:

>I want to follow the progress within a PL/SQL block.
>A problem is that Oracle doesn't show the results directly (afterwards) and
>I get the following error:
>ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>ORA-06512
>
>Can somebody tell me how tot manage progress within PL/SQL?
>
>
>
>set serveroutput on
>
>LOOP
> ....
> ....
> my_counter := my_counter + 1;
> IF ins_teller MOD 10000 = 0
> THEN SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS') INTO t_sysdate
>FROM DUAL;
> dbms_output.put_line('processed ' || my_counter || ' ' ||
>t_sysdate);
> END IF;
>END LOOP

--

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