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 in a PL/SQL loop...

Re: dbms_output in a PL/SQL loop...

From: <Kenneth>
Date: Sat, 18 Jan 2003 11:11:45 GMT
Message-ID: <3e2933c0.680348@news.inet.tele.dk>


Hi Gilles,

I suggest you either

  1. Create a small indicator table, insert the indicator value into that, commit and keep an eye on that table from another session. This forces you to do a commit inside the loop which is impractical or even erronous if you are doing a large transaction through the loop and other tracsactions update the objects you are accessing.

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

Original text of this message

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