RE: PL/SQL question

From: Bancea, Danut <Danut.Bancea_at_bmo.com>
Date: Tue, 9 Oct 2012 14:06:38 -0400
Message-ID: <475356FF5907144FA3D319BAEA39105CAA647ADD_at_BMFGEXCMBX05.adroot.bmogc.net>



Hi,

Maybe this will work.

Select StatusInfoLine from dual;

The result will be in the output file.

Danut Bancea
Tel: 416 643 1631

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ricard Martínez Sent: October 9, 2012 1:59 PM
To: oracle-l_at_freelists.org
Subject: Re: PL/SQL question

Hello
Yup thats right, but i mean a way to do it in the output buffer without using a table or utl_file.
Also dbms_application_info doesnt seems to fit neither. Thanks anyway

Any more suggestions?

Regards

On Tue, Oct 9, 2012 at 6:51 PM, Bancea, Danut <Danut.Bancea_at_bmo.com> wrote:

> Hi,
>
> You can use a log table or utl_file to write the information.
>
>
> Danut Bancea
> Tel: 416 643 1631
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Ricard Martínez
> Sent: October 9, 2012 1:46 PM
> To: oracle-l_at_freelists.org
> Subject: PL/SQL question
>
> Hello
> I know i can use dbms_output.put_line to write information to the output
> buffer when using pl/sql.
> But if i have a loop that must delete 1 million rows, its is possible to
> write the info meanwhile the loop is working??
>
> Like:
>
> SQL> exec user.deleteprocdure;
>
> 1000 rows deleted.
> 2000 rows deleted.
> 3000 rows deleted.
>
>
> Instead of waiting till the loop completes all the deletes and the see all
> the info at same time, i want to see the info meanwhile the loop is
> working.
> Its that possible?
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 09 2012 - 20:06:38 CEST

Original text of this message