| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> What's wrong with DBMS_OUTPUT.PUT_LINE buffer overflow?
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;
![]() |
![]() |