Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output in a PL/SQL loop...
Hi Gilles,
I suggest you either
OR
b) Use the dbms_application_info.set_session_longops built-in package. This does basicly the same as a), except that the indicator is stored in a system view ( V$SESSION_LONGOPS) and you *don't need to commit* to let other sessions see the content of V$SESSION_LONGOPS. The safest choice. See on-line doc. for furter details.
On Sat, 18 Jan 2003 11:40:44 +0100, "Gilles Mercier" <gilles.mercier_at_urbanet.ch> wrote:
>Hi,
>I have been trying to put a dbms_outoput.put_line in a PL/SQL Loop to get a
>"real time" print of where the loop actually is working, but it seem that
>all the output records print on the screen only when the loop is finished...
>
>Does anybody know how to get a "real time advance indicator" for a PL/SQL
>loop ?
>
>Thanks in advance for your help...
>
>Gilles
>
>
Received on Sat Jan 18 2003 - 05:11:45 CST