Autonomous txn over db link

[anthony_t]

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!

[julian]

Autonomous transactions are not supported within distributed transaction in Oracle8i. They are supported in 9i.

Are you using 8.1.7 or below?

[anthony_t]

Thanks mate.

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.

Thanks again.