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
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 Go to next message
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

----------------------------------------------------------------------
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 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
dbms_output.put_line(sql%rowcount);

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


Current Time: Wed Dec 25 10:05:53 CST 2024