You can use the AutoCommit method to solve. For example: Create or Replace Trigger Trigger_name [Before | After] action on table_name for each row declare pragma autonomous_transaction begin ... commit; end;