Re: How to get output text immediately

"Robert Wehofer" <thalion77_at_graffiti.net> wrote in message news:c282b$43785048$d4badae4$5308_at_news.chello.at...
> Hello there!
>
> If I call DBMS_OUT.PUT_LINE before a long process (loop), the text is
> shown
> after the process. Is it possible to get the text on screen immediately
> before the process is starting? I need some kind of flush function.
>
> Regards,
> Robert
>
>

not possible with DBMS_OUTPUT, since it buffers output which is accessible in the current session by the calling program (i'll assume SQL*Plus, you did not specify) after the calling prorgam regains controls and can issue DBMS_OUTPUT.GET_LINE calls (which SQL*Plus and other programs do automatically)

to monitor status of a process while it is running, including debug messages, the messages have to be made available to another session, via such mechanisms as:

-- writes to a table (with an autonomous transaction)
-- writes to a file (with the UTL_FILE package)
-- writes to a database pipe (with the DBMS_PIPE package)
-- writes to a queue (with the DBMS_AQ package)

++ mcs Received on Mon Nov 14 2005 - 05:34:17 CST