OraFAQ Forum: SQL & PL/SQL » how do i print the no of records affected after my insert/update/delete statements in my procedure

Home » SQL & PL/SQL » SQL & PL/SQL » how do i print the no of records affected after my insert/update/delete statements in my procedure

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

how do i print the no of records affected after my insert/update/delete statements in my procedure [message #36321]

Fri, 16 November 2001 03:30

srin
Messages: 3
Registered: November 2001

Junior Member

Hi,
how do i print the no of records affected after my insert/update/delete statements in my procedure

Srini

----------------------------------------------------------------------

Report message to a moderator

Re: how do i print the no of records affected after my insert/update/delete statements in my procedu [message #36324 is a reply to message #36321]

Fri, 16 November 2001 06:58

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

dbms_output.put_line(sql%rowcount);

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Trigger - help!!!
Next Topic:	open cursor problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:07:49 CST 2024