Autonomous txn over db link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Autonomous txn over db link

  1. #1
    Join Date
    Sep 2001
    Location
    Australia
    Posts
    18

    Talking

    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!

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Autonomous transactions are not supported within distributed transaction in Oracle8i. They are supported in 9i.

    Are you using 8.1.7 or below?



  3. #3
    Join Date
    Sep 2001
    Location
    Australia
    Posts
    18
    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
  •  



Click Here to Expand Forum to Full Width