Re: How to get output text immediately

"Mark C. Stock" <mcstockX_at_Xenquery .com> a écrit dans le message de news: xa6dnafKT6um6-XenZ2dnUVZ_sydnZ2d_at_comcast.com...
|
| "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
|

You can also use dbms_application_info.set_client_info and query v$session.

Regards
Michel Cadot Received on Mon Nov 14 2005 - 10:45:25 CST