Search notes:

ORA-04092: cannot COMMIT in a trigger

A trigger cannot commit the transaction which fired the trigger (but its possible to execute a trigger in an autonomous transaction.

create table tq84_ora_04092_tab (a number);
 
create or replace trigger tq84_ora_04092_trg
   after insert on tq84_ora_04092_tab
begin
   commit;
end tq84_ora_04092_trg;
/
 
insert into tq84_ora_04092_tab values (42);
-- SQL Error: ORA-04092: cannot COMMIT in a trigger
-- ORA-06512: at "RENE.TQ84_ORA_04092_TRG", line 2
-- ORA-04088: error during execution of trigger 'RENE.TQ84_ORA_04092_TRG'
  
drop table tq84_ora_04092_tab;

ORA-04092: cannot COMMIT in a trigger

See also