We have two tables. Table A and Table B. We have a “row level” trigger on Table A and are using the “NEW” values, we want to update Table B when certain criteria pulled from Table A are met. Triggers have problems issuing “COMMIT’s” so we’re utilizing the “PRAGMA AUTONOMOUS_TRANSACTION” command in our trigger declaration. Our update statement is still not committing though.



We are positive that the procedure is getting to our UPDATE and that our WHERE clause is correct because we are inserting records into a message log throughout the procedure. In addition we also populated a variable with the COUNT from a select on the WHERE clause and inserted that into the message log as well. Everything is as would be expected.



However our UPDATE is still not committing. (We have COMMIT’s in several places of the code including directly after our update).



Any thoughts?