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"
Autonomous transactions are not supported within distributed transaction in Oracle8i. They are supported in 9i.
Are you using 8.1.7 or below?
I found that same info on metalink but was hoping that someone knew a workaround.
I'm using Oracle 8.1.7 so maybe I can convince the powers that be to upgrade to 9i!
I have since found a different solution that does not require database links so its look like everything is cool.
Click Here to Expand Forum to Full Width