Re: PL/SQL question

Mike

• On Tue, 10/9/12, Ricard Martínez <ricard.martinez_at_gmail.com> wrote:

From: Ricard Martínez <ricard.martinez_at_gmail.com> Subject: PL/SQL question
To: oracle-l_at_freelists.org
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

--

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

--

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