-
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!
-
Autonomous transactions are not supported within distributed transaction in Oracle8i. They are supported in 9i.
Are you using 8.1.7 or below?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|