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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ricard Martínez Sent: October 9, 2012 1:46 PM To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l