MySQL Forums
Forum List  »  Triggers

Re: Trigger not firing when change to table occurs w/in a PROC
Posted by: Ralph Smith
Date: December 01, 2015 08:32PM

I also have a FOREIGN_KEY_CHECKS=0 in there.

Of course it's possible to put the Trigger's code in the procedure, but UGLY!!!
What if things change in the near future and they make it work, I'd then have two inserts into table B.

If it turns out I'm trying to do the impossible
I'm going to look up whether MySQL Triggers can call a procedure, and if so call that procedure w/in my event-triggering proc.
But only if I have to do this ugly fix!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Trigger not firing when change to table occurs w/in a PROC
887
December 01, 2015 08:32PM


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.