Hi, Maybe this will work. Select StatusInfoLine from dual; The result will be in the output file. 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:59 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: PL/SQL question Hello Yup thats right, but i mean a way to do it in the output buffer without using a table or utl_file. Also dbms_application_info doesnt seems to fit neither. Thanks anyway Any more suggestions? Regards On Tue, Oct 9, 2012 at 6:51 PM, Bancea, Danut <Danut.Bancea@xxxxxxx> wrote: > 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 -- //www.freelists.org/webpage/oracle-l