MySQL Forums
Forum List  »  Triggers

Stored procedures and triggers
Posted by: Andrew Thornberry
Date: January 06, 2012 12:43AM

Hi all,

am not sure if this is a newbie question or a real problem. I have a DELETE trigger on a table that does 'stuff'. When I delete data, the 'stuff' gets done. Then I create a stored procedure that does the delete of data - the trigger does not fire.

I have searched for text telling me that a trigger wont fire from a table updated via an SP, but cannot see that (and cannot see why you would want to do stop that).

I am trying to go down the SP and trigger path together, so assume it should work???

regards
andrew

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored procedures and triggers
1908
January 06, 2012 12:43AM
999
January 17, 2012 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.