PL/SQL question
From: Ricard Martínez <ricard.martinez_at_gmail.com>
Date: Tue, 9 Oct 2012 18:45:48 +0100
Message-ID: <CAFGV9um1HAKQ8eAB5TCc1Wy=4C2NuPvp6wPp_FrwK8aeDqz5mw_at_mail.gmail.com>
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??
Date: Tue, 9 Oct 2012 18:45:48 +0100
Message-ID: <CAFGV9um1HAKQ8eAB5TCc1Wy=4C2NuPvp6wPp_FrwK8aeDqz5mw_at_mail.gmail.com>
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-lReceived on Tue Oct 09 2012 - 19:45:48 CEST