Re: DBMS_OUTPUT.PUT_LINE - any alternative

From: Frederic DEBRUS <frederic.debrus_at_ces-cdr.be>
Date: 27 Aug 1999 12:12:53 GMT
Message-ID: <01bef086$8f15b140$3e35a99e_at_gal159a>


[Quoted] [Quoted] You must change the buffer size look below

hope this help
ciao
FreD

The ENABLE procedure enables calls to the other DBMS_OUTPUT modules. If you do not first call ENABLE, then any other calls to the package modules are ignored. The specification for the procedure is,

PROCEDURE DBMS_OUTPUT.ENABLE
   (buffer_size IN INTEGER DEFAULT 20000);

buffer_size The size of the buffer that will contain the information stored by calls to PUT and PUT_LINE. The buffer size can be as large as 1,000,000 bytes. You can pass larger values to this procedure without raising an error, but doing so will have no effect besides setting the buffer size to its maximum.

You can call ENABLE more than once in a session. The buffer size will be set to the largest size passed in any call to ENABLE. In other words, the buffer size is not necessarily set to the size specified in the last call.

If you want to make sure that the DBMS_OUTPUT package is enabled in a program you are testing, add a statement like this one to the start of the program:

DECLARE
   ... declarations ...
BEGIN
   DBMS_OUTPUT.ENABLE (1000000);
   ...
END; Received on Fri Aug 27 1999 - 14:12:53 CEST

Original text of this message