Home » SQL & PL/SQL » SQL & PL/SQL » Capture Feedback in Procedure
Capture Feedback in Procedure [message #35886] Mon, 22 October 2001 08:40 Go to next message
scott
Messages: 73
Registered: September 1999
Member
I've got a stored procedure that deletes table records. Anyone know a way to capture the feedback (e.g. 80 rows deleted) into a variable in the procedure? I know I could do a 'Select count(*) into VARIABLE ...' before I do the delete, but that method won't work for me in this case.

Thanks for the Help.
Scott

----------------------------------------------------------------------
Re: Capture Feedback in Procedure [message #35888 is a reply to message #35886] Mon, 22 October 2001 09:38 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
after sql statement , get sql%rowcount. it will give number of rows affected by recent sql query.

SURESH

----------------------------------------------------------------------
Previous Topic: urgent
Next Topic: SET TRANSACTION in a stored Procedure
Goto Forum:
  


Current Time: Thu Apr 02 02:24:19 CDT 2020