V7 dbms_output question

Does anyone know of a way get around the following buffer limitation error

ERROR:
ORA-06512: at line
ORA-06512: at line 1

declare
 *
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes ORA-06512: at line 37

in V7 while using the following code in a PL/SQL script

   dbms_output.put_line('LABEL1: '||d1.var1);
   dbms_output.put_line('LABEL2: '||d1.var2||' '||d1.var3);
   dbms_output.put_line('LABEL3: '||d1.var4||d1.var5);
   dbms_output.put_line(chr(10));
   for d2 in c2(d1.var1, d1.var2) loop
      dbms_output.put_line('LABEL4: '||d2.var6||' '||d2.var7);
      dbms_output.put_line('LABEL5: '||d2.var8||' '||d2.var9);
   end loop;
         

dbms_output.put_line(chr(10));

end loop;
end;
.
/
spool off
exit

server output is ON and the size is 1000000(the maximum). c1 and c2 are cursors. I was trying to use some of the output capability in V7 to print a large report. Is there a way to flush what is in the buffer (before the max buffer size is reached) then proceding with the rest of the report?

Thanks,

Dennis Glover (g596083_at_mip.lasc.lockheed.com) Received on Tue Jan 04 1994 - 19:36:33 CET