No after statement trigger
Has anyone found a workaround for the lack of an "after statement" trigger? In my application, an "after insert for each row" won't work by itself. In Oracle, I was using "after insert for each row" to generate typically multiple new rows for each inserted row, and hold them in a temporary location. Then, the after statement trigger processed the contents of the temporary location and generated multiple inserts into the original target table, after applying some business rule logic to each one. (Note: the generated data and the trigger code were coordinated to avoid recursive firing on the generated inserts.)
It works fine in Oracle, but I don't see any way to do it with server-side computing in MySQL.
Subject
Views
Written By
Posted
No after statement trigger
1916
November 20, 2016 03:48PM
748
November 20, 2016 07:38PM
928
November 20, 2016 11:17PM
772
November 20, 2016 11:39PM
874
November 20, 2016 11:56PM
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.