OraFAQ Forum: SQL & PL/SQL » displaying updated rows on screen

Home » SQL & PL/SQL » SQL & PL/SQL » displaying updated rows on screen

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

displaying updated rows on screen [message #37432]

Thu, 07 February 2002 05:48

Vinod
Messages: 76
Registered: April 1999

Member

Hi
Iam updating rows through a PL/SQL procedure. I want to know how many rows have been updated. How do I do that. I have counter which I use for commits. I wrote
DBMS_OUTPUT.PUT_LINE(c_kounter). All it does is after the procedure is completed all the c_kounter is displayed. I want a dynamic display. It commit 10,000 rows the screen should display 10000 rows update it updates the next 10000 it should that. How can I do this.
Thanks in advance

Vinod

Report message to a moderator

Re: displaying updated rows on screen [message #37433 is a reply to message #37432]

Thu, 07 February 2002 06:37

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

Hi,

The DBMS_OUTPUT package does not contain any mechanism for printing . it implements a first in , first out data structure.

The third party tool like sql*plus have option set serveroutput on and these tool call dbms_output.get_lines to retrieve the data from buffers only when pl/sql block is completed.so it is not possible to echo the output to screen when pl/sql block is executed.

Hope it helps!!!

cheers
pratap

Report message to a moderator

Re: displaying updated rows on screen [message #37488 is a reply to message #37432]

Mon, 11 February 2002 19:38

Ripu
Messages: 3
Registered: February 2002

Junior Member

Hi,

Within plsql block take count of rows u r updating ( means take from and where clause of your update statement and have count in a variable ); print it with dbms_output.put_line(var_name );

i think this will help u.
Regards

Report message to a moderator

Re: displaying updated rows on screen [message #37540 is a reply to message #37488]

Wed, 13 February 2002 09:07

Vinod
Messages: 76
Registered: April 1999

Member

I am sorry I did not follow your reply. Could you please explain it one more

Thanks in advance

Report message to a moderator

Previous Topic:	batch processing
Next Topic:	HOST() command in PL/SQL ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 13 12:48:41 CDT 2025