Re: Ora-00164: Autonomous and Distributed transactions

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 22 Feb 2005 06:33:11 -0800
Message-ID: <1109082791.790966.218710@c13g2000cwb.googlegroups.com>

The ORA-00164 error in version 8.1.7 is not a bug. It was clearly stated in the 8.1.7 documentation that anonymous transactions could not be called as part of a distributed transaction. Oracle removed this limitation in version 9.

The workaround is not to call the anonymous transaction as part of the distributed transaction. In some cases the remote query can be issued and then committed to end the transaction allowing a new transaction to process the anonymous transaction. But what you can do depends on the logical unit of work that you are dealing with and where the remote query lies.

HTH -- Mark D Powell -- Received on Tue Feb 22 2005 - 08:33:11 CST