Hello all,
I have an AFTER INSERT trigger which inserts data in table B when new rows are inserted in table A.
New rows are inserted in table A by clicking the Save button in Forms 10. There is a COMMIT statement in the PL/SQL code for this button.
My question is: since I would like to commit the inserts in table B as well, should I make the trigger a BEFORE INSERT trigger,
so that the COMMIT statement in the Save button commits both the insert in table A , as well as table B?
Thank you.