Re: PL/SQL question

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 9 Oct 2012 21:58:18 +0400
Message-ID: <CAOVevU5nbkdgxJbLNwYiSpCd0OLRjFCn8aiz8KB9xC-+bm+qKg_at_mail.gmail.com>

You can use dbms_application_info package, for example set current state with dbms_application_info.set_session_longops and retrive in another session from v$session_longops

On Tue, Oct 9, 2012 at 9:45 PM, Ricard Martínez <ricard.martinez_at_gmail.com> wrote:
> Hello
> 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
>
>

-- 
Best regards,
Sayan Malakshinov
Senior oracle developer
PromSvayzBank
Tel: +7 903 207-1576
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 09 2012 - 19:58:18 CEST