Re: dbms_output (buffer overflow)

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

I presume you are executing your PL/SQL from SQL*Plus. So you need to specify SET SERVEROUT[PUT] ON SIZE nnnnn (Note that the ON is required, even if it is already on!) Received on Wed Feb 19 1997 - 00:00:00 CST