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???


Options: ReplyQuote

Written By
Stored procedures and triggers
January 06, 2012 12:43AM
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.