RE: PL/SQL question
Date: Tue, 9 Oct 2012 13:51:08 -0400
Message-ID: <475356FF5907144FA3D319BAEA39105CAA647AA4_at_BMFGEXCMBX05.adroot.bmogc.net>
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
Received on Tue Oct 09 2012 - 19:51:08 CEST