Re: SET SERVEROUTPUT Question
From: Christopher Jones <cjones_at_au.oracle.com>
Date: 20 Aug 1994 03:57:49 GMT
Message-ID: <CJONES.94Aug20135749_at_hurrah.au.oracle.com>
Date: 20 Aug 1994 03:57:49 GMT
Message-ID: <CJONES.94Aug20135749_at_hurrah.au.oracle.com>
>Tim McCollum (edtwm_at_huber.com) wrote:
>: 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.
>: 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??????
If you use SQL*Plus, you'll see that SET SERVEROUTPUT has an optional SIZE parameter to set the buffer size.
Chris Received on Sat Aug 20 1994 - 05:57:49 CEST