Re: Trigger on commit

Dependent on you db-version you could look into autonomous transactions voor logging into a second table. When you don't have this feature:
Try using DBMS_JOB.

In the after statement trigger submit a dbms_job, executing your piece of code.
When the original transaction commits => the job is submitted When the original transaction rollbacks => the job is not submitted

In the job you can do whatever you want, independent of the original transaction Received on Tue Feb 05 2002 - 12:34:36 CET