Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Ora-00164: Autonomous and Distributed transactions

Ora-00164: Autonomous and Distributed transactions

From: Frank Piron <empty_at_zero.nil>
Date: Mon, 21 Feb 2005 14:23:35 +0100
Message-ID: <opsmjt5liym0et4w@news.online.de>


Hi,
we encounter an ora-00164 in a procedure using an autonomous transaction.
RDBMS: Oracle 8.1.7.4
OS: Solaris 2.8 on an ULTRA Sparc (64Bit)

I searched metalink and detected the reason as a db-link to a financial database.
We only select tables of the remote db, no DML. The issue is filed as a bug and resolved in Oracle 9.2

Question: Is there a workaround for using autonomous  transactions and read-only db-links in Oracle 8.1.7.4 (e.g. setting distributed_transactions = 0 in initSID.ora)?

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)
Received on Mon Feb 21 2005 - 07:23:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US