Hi,
Does Oracle support Autonomous Transactions.
i want to issue a commit inside a database trigger.
how can i use Autonomous Transactions to achive this.

Please Help...

Yes you can, first declaration in your declare section hast to be "pragma autonomous_transaction".

Good Luck!


Remi

http://askremi.ora-0000.com

Hi,
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.