Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output

Re: dbms_output

From: ALEX J JENTILUCCI <AlexJent_at_prodigy.net>
Date: 1998/02/21
Message-ID: <6cnedc$2qes$1@newssvr08-int.news.prodigy.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US