dbms_output (buffer overflow)

From: Rami Juhela <rami_at_lego.ll.utu.fi>
Date: 1997/02/19
Message-ID: <5eeql5$gea@news.utu.fi>#1/1

Is there any way to prevent buffer overflow when using dbms_output.put_line in PL/SQL -cursor loop? (Oracle7).

I have a PL/SQL -skript which outputs about 200 - 300 lines and the script uses dbms_output.put_line in three nested cursor loops. However, it seems that the output buffer is too small for this purpose. Script halts after printing several lines and produces an error message:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

I've checked manuals but I didn't found a solution. I even tried 'SET FLUSH ON', which according to SQL*Plus user guide disables output buffering. It didn't help. Any suggestions???

/Rami Juhela
rajuhela_at_utu.fi Received on Wed Feb 19 1997 - 00:00:00 CST