Re: Performance Question - trigger
From: Edwin <vanmeerendonk_at_wxs.nl>
Date: 5 Aug 2002 03:45:38 -0700
Message-ID: <31354201.0208050245.5642c2a3_at_posting.google.com>
Date: 5 Aug 2002 03:45:38 -0700
Message-ID: <31354201.0208050245.5642c2a3_at_posting.google.com>
A way to do this is with the help of DBMS_JOB. In the trigger of your need (e.g. the after-insert row) you can start a pl/sql-program with dbms_job that can run on the background. This way, when the user rollbacks, your job is draw back as well an with a commit the job is submitted. With this background job, the user isn't aware of any performance loss.
However, you have to take care of exception-handling in the background job, 'cause you lost the link back to the parent-session. Received on Mon Aug 05 2002 - 12:45:38 CEST