OraFAQ Forum: SQL & PL/SQL » Capture Feedback in Procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Capture Feedback in Procedure

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

Capture Feedback in Procedure [message #35886]

Mon, 22 October 2001 08:40

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

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

Report message to a moderator

Re: Capture Feedback in Procedure [message #35888 is a reply to message #35886]

Mon, 22 October 2001 09:38

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:27:39 CDT 2024