Hi,

I have built a trigger which calls a procedure. This procedure in turn calls procedures within a package. The procedures within the package have commit statements within them.

When the trigger fires the following error occurs:

ORA-04092 cannot commit in a trigger

Is there any way around this? Alternatively, how else can you schedule things to run in Oracle when certain conditions are met that are not time related (i.e. a data change)?

Thanks for your help