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 -> Re: Ora-00164: Autonomous and Distributed transactions

Re: Ora-00164: Autonomous and Distributed transactions

From: Frank Piron <empty_at_zero.nil>
Date: Tue, 22 Feb 2005 16:32:30 +0100
Message-ID: <opsmlusgxpm0et4w@news.online.de>


Am 22 Feb 2005 06:33:11 -0800 schrieb Mark D Powell <Mark.Powell_at_eds.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.

I should have been more clear:
The bug is that the poor *existence* of a db-link suffices to cause the error.
No distributed transaction has to be involved! This is Bug No:692232.

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)
Received on Tue Feb 22 2005 - 09:32:30 CST

Original text of this message

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