Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output in a PL/SQL loop...
My preference is to use the utl_file package.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____England______January 21/23 ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Gilles Mercier wrote in message <3e292f2f$1_at_news.swissonline.ch>...Received on Sat Jan 18 2003 - 09:22:12 CST
>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
>
>