Re: Buffer Size and DBMS_OUTPUT

[Quoted] After every commit; the buffer is empty, thus giving you indefinite space !!!

hope it helps

Klaus Kloeser
k.kloeser_at_consultingteam.de
Jose Luis Perez schrieb in Nachricht <3645DD86.3FA44C08_at_mx2.redestb.es>...
>
>
>Kevin Bass wrote:
>
>> The maximum buff size for DBMS_OUTPUT is 1,000,000. I would like to get
>> around this maximum buff size without using UTL_FILE.
>>
>> (1) How can I determine and/or review the buff size of DBMS_OUTPUT before
 it
>> is reached?
>>
>> (2) Is there a function or tool that can display the buff size before the
>> maximum is reached.
>>
>> (3) Are there tools created that will get around the maximum buff size of
>> DBMS_OUPUT?
>>
>> Kevin
>
>Hello Kevin
>
>You can use set the buffer size to 1,000,000, default size is 2000 bytes
>
>If you do the following
>
>set serveroutput on size 1000000
>_at_my_plsql_script
>set serveroutput off
>
>you can see also the package spec of dbms_output that includes a litle
>documentation
>
>set heading off
>set linesize 132
>select text
>from all_source
>where name='DBMS_OUTPUT'
>
>
>Hope this can help you !!
>
>Kind Regards
>Jose Luis Perez
>perezjl_at_mx2.redestb.es
>
>
>
>
Received on Fri Nov 13 1998 - 00:00:00 CET