Re: SET SERVEROUTPUT Question

In article <32toqd$nbj_at_muddy.huber.com>, edtwm_at_huber.com (Tim McCollum) writes:
|> please reply post or reply to edtwm_at_huber.com
|>
|> I have a pl/sql script for which I would like to send a debug message.
|>
|> example:
|>
|> begin
|>
|> loop
|>
|> -- please ignore endless loop it is of no consequence to the
|> -- example
|> dbms_output.put_line('Hello World!');
|>
|> end loop;
|>
|> end;
|>
|> I realize that I must do set servoutput on prior to executing the procedure.
|> The problem is that there is a buffer limit of 2000 bytes. The result is
|> when put_line attempts to put the 2001st byte to the buffer, I receive
|> ORA-20000 Buffer Overflow error.
|>
|> Does anyone know how to change the 2000 byte buffer limit??????
|>
|> Tim McCollum
|> Oracle Services
|> Iselin NJ

You can use 'set serveroutput on size 1000000'. This increases the buffer to the maximum size, which is 1,000,000 bytes. You can also call dbms_output.enable(1000000) which does exactly the same thing. enable() has a default of 2000 if you don't specify it, which is what you do when you don't specify the size on the 'set serveroutput on' command. Received on Thu Aug 18 1994 - 02:06:04 CEST