Re: PL/SQL question
- From: mike boligan <mboligan@xxxxxxxxx>
- To: ricard.martinez@xxxxxxxxx
- Date: Tue, 9 Oct 2012 11:42:32 -0700 (PDT)
This should work for you:
http://www.oracle-base.com/articles/misc/autonomous-transactions.php
Mike
--- On Tue, 10/9/12, Ricard Martínez <ricard.martinez@xxxxxxxxx> wrote:
From: Ricard Martínez <ricard.martinez@xxxxxxxxx>
Subject: PL/SQL question
To: oracle-l@xxxxxxxxxxxxx
Date: Tuesday, October 9, 2012, 1:45 PM
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
