Originally posted by NoviceNo1
Cool.. Thanks it worked.
You must be aware that by making this trigger autonomous, its work falls outside the scope of the main transaction - i.e. if the user issues a ROLLBACK of the triggering statement, the work done by the trigger will remain. Of course, that may be exactly what you want if you are doing something like logging user activity, but for some situations it would be the wrong thing to do, and could corrupt your database.