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
Messages: 73
Registered: September 1999
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.

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.


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

Current Time: Thu Jun 17 22:44:37 CDT 2021