I have an row level after insert trigger on table DEPT which calls a stored procedure to dynamically create a trigger on a different table based on the values inserted into table DEPT. I get the following error :
ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "SCOTT.PKG_GENERATE_TRIGGERS", line 166
ORA-06512: at "SCOTT.PKG_GENERATE_TRIGGERS", line 277
ORA-06512: at "SCOTT.TRG_RA_INS_DEPT", line 3
ORA-04088: error during execution of trigger 'SCOTT.TRG_RA_INS_DEPT'
I understand that you cannot have any commits inside the trigger body, however the same happens on an Alter trigger based at the schema level which is supposed to allow CREATE statements in the trigger body. Does anyone know how I get around this problem.
I am using Oracle8i 8.1.5.
Any help is appreciated greatly.