Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What's wrong with DBMS_OUTPUT.PUT_LINE buffer overflow?

What's wrong with DBMS_OUTPUT.PUT_LINE buffer overflow?

From: Internet Nieuwsserver <flesterh_at_gak.nl>
Date: Tue, 4 Aug 1998 17:49:37 +0200
Message-ID: <6q7akt$4oh$1@news.gns.getronics.nl>


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 Received on Tue Aug 04 1998 - 10:49:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US