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 have a PL/SQL -skript which outputs about 200 - 300
> lines and the script uses dbms_output.put_line in
> < stuff deleted >
>
> ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
>

IN SQL*Plus use: SET serveroutput ON SIZE <buffer size> IN PL/SQL use: DBMS_Output.Enable ( <buffer size> )

In both cases the buffer size can be up to 1,000,000 bytes

-- 
Howard Gluckman
Data Architect
U S WEST Communications
hgluckm_at_uswest.com

Any opinions are personal, and do not represent U S WEST Communications.