RE: ORA-00164

From: Petr Sobotka <petrsobotka_at_yahoo.com>
Date: Fri, 31 May 2002 13:53:40 -0400
Message-ID: <ad8enl$ld1$1@av2.rz.fh-augsburg.de>

> ORA-00164: autonomous transaction disallowed within distributed
transaction

Well, now I understand what autonomous transaction means but I don't know why I get this message because I don't (explicitly) use them. I have a sequence of actions like this:

UPDATE -> acivates trigger -> calls procedure -> makes UPDATE -> activates trigger -> calls procedure -> calls a procedure in another DB server

And this results in ORA-00164. Why ?
Petr Received on Fri May 31 2002 - 12:53:40 CDT