Re: PL/SQL DBMS_OUTPUT buffer limit
Date: 05 Jun 2002 08:53:52 +1000
Message-ID: <871ybmvenz.fsf_at_blind-bat.une.edu.au>
[Quoted] [Quoted] Daniel Morgan <dmorgan_at_exesolutions.com> writes:
> Try this at the beginning of your procedure
>
> BEGIN
> DBMS_OUTPUT.DISABLE;
> DBMS_OUTPUT.ENABLE(1000000);
>
> If that isn't large enough ... make the buffer larger.
>
Can I ask for some clarification here? Still pretty much a newbie with
Oracle, but from all I have read, I thought there was a limit of
1000000 to the buffer size for DBMS_OUTPUT? If I've needed to output
more than 1Mb I've used temporary tables and then followed the plsql
block with a simple select on the temporary table. If you can actually
avoid this by setting a buffer larger than 1Mb life would be a lot
easier. If it can be set above this limit, what is the new limit and
on which Oracle/plsql versions can this be done?
Tim Received on Wed Jun 05 2002 - 00:53:52 CEST