Re: How to force a flush of dbms_output.put_line

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/02
Message-ID: <3392a064.9481133@www.sigov.si>#1/1

On 1 Jun 1997 15:39:34 GMT, maverick_at_videotron.ca (Pierre) wrote:

>This is not normal behavior.
>Send me your procedure, I'll take a look at it.

Don't bother looking at it, because the described behavior of DBMS_OUTPUT is (unfortunately) perfectly normal. Output can not be displayed until PL/SQL program completes (the whole program, not just sub-block!) and returns controll to its caller (SQL*Plus for example). There is no way to flush DBMS_OUTPUT buffer from inside of PL/SQL program!

>
>CIAO Pierre
>

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Mon Jun 02 1997 - 00:00:00 CDT