Re: PL/SQL DBMS_OUTPUT buffer limit

Tim Cross wrote:

> Daniel Morgan <dmorgan_at_exesolutions.com> writes:
>
> > Kjell Ove Skarsbø wrote:
> >
>
> > 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

You are likely correct. I didn't count the zeros in my example.

Daniel Morgan Received on Wed Jun 05 2002 - 01:28:54 CEST