Re: dbms_output in a PL/SQL loop
From: Ban Spam <ban-spam_at_operamail.com>
Date: Sat, 18 Jan 2003 15:46:39 GMT
Message-ID: <Xns93074F647BAE5SunnySD_at_68.6.19.6>
Date: Sat, 18 Jan 2003 15:46:39 GMT
Message-ID: <Xns93074F647BAE5SunnySD_at_68.6.19.6>
"Gilles Mercier" <gilles.mercier_at_urbanet.ch> wrote in news:3e292f5d$1_at_news.swissonline.ch:
> 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
> --
>
>
>
Look at DBMS_APPLICATION_INFO
HTH & YMMV HAND! Received on Sat Jan 18 2003 - 16:46:39 CET