MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Trigger not firing when change to table occurs w/in a PROC
1549
Ralph Smith
December 01, 2015 08:24PM
Re: Trigger not firing when change to table occurs w/in a PROC
887
Ralph Smith
December 01, 2015 08:32PM
Re: Trigger not firing when change to table occurs w/in a PROC
793
Peter Brawley
December 01, 2015 10:02PM


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.