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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 18 Jan 2003 15:22:12 -0000
Message-ID: <b0bse6$fo4$1$830fa78d@news.demon.co.uk>

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>...

>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 - 09:22:12 CST

Original text of this message

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