Re: buffer overflow, limit of 2000 bytes (how to get around)

silversw2000_at_yahoo.com (Fred Zimmerman) writes:

> In PL-SQL I run the following SQL Script, and
> get the buffer overflow message; how do I get rid
> of the message, and/or increase the buffer?
>

DBMS_OUTPUT has a buffer limit of 1000000 bytes. There is no way around this AFAIK.

The DBMS_OUTPUT is really only useful as a debugging tool.

Some workarounds are -

1. Use UTL_FILE and write the output to a file
2. Insert the data into a table and then query from that table

Personally, I prefer to use the first method. I like to avoid the second method as it is a type of solution which tends to lead to temporary tables popping up all over the place. However, if you do decide to use method 2 and your running 8i or later, look into temporary global tables (or is it global temporary tables) - whichever, if you have/want to use temporary tables, they are better than just creating a normal table in your default tablespace etc.

Tim Received on Wed Nov 20 2002 - 16:30:45 CST