Re: dbms_output

I've never gotten that (dbms_output.enable(1000000) ) to work as expected either....

There is no "flush buffer".

What you need to do is : SET SERVEROUTPUT ON SIZE 1000000 prior to running you code.

That is maximum(1000000). If you still exceed the buffer you'll have to resort
to DBMS_UTIL routine.

Good luck,
Alex

Lynne Cochrane wrote in message <34ED8671.AB9B8652_at_email.sps.mot.com>...
>Hello All,
>
>I'm having some problems using the dbms_output packaged procedure. When
>using this I am running out of buffer space. I set the buffer using the
>dbms_output.enable() to the maximum. I am trying to reset the buffer by
>using the dbms_disable followed by the dbms_enable command again.
>However, this doesn't seem to work. Can someone please tell me how to
>flush this buffer.
>
>Thanks in advance
>
>Lynne.
Received on Sat Feb 21 1998 - 00:00:00 CST