Hi,

Can anybody suggest a way to implement an autonomous transaction over a database link using PL/SQL. The idea is to commit the autonomous transaction (such as an insert into a table) regardless of whether the main thread is committed or rolled back.

Whenever I try I receive the following Oracle error :
"ORA-00164: autonomous transaction disallowed within distributed transaction"

Cheers!