Re: SET SERVEROUTPUT Question

In article 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

Check the script: $ORACLE_HOME/rdbms/admin/dbmspipe.sql

  function send_message(pipename in varchar2,

                        timeout in integer default maxwait,
                        maxpipesize in integer default 8192)

Good Luck!

Sincerely,

Martin Farber
Independent Oracle Consultant

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216