MySQL Forums
Forum List  »  Triggers

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

Hi,

I have an AFTER INSERT trigger on table A that successfully inserts some info in to table B when triggered.

Now I have a procedure that inserts into table A, but the trigger apparently isn't firing.

I also had a START TRANSACTION ;..... COMMIT ; around the insert into table A, however I took it out and have the same problem.

Any wise(wo)men out there savvy with a trigger firing when the event occurs w/in a procedure?

Thanks!

Options: ReplyQuote


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


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.