Re: ORA-00164

From: Liggs <liggs_at_hotmail.com>
Date: Fri, 31 May 2002 20:35:27 +0000 (UTC)
Message-ID: <ad8mqe$109$1@paris.btinternet.com>

How are you calling the other procedure ?

I think this used to work in 8.1.6 but not in 8.1.7+. I suspect Oracle must have encountered problems with the 2 phase commit bit and took it out.

"Petr Sobotka" <petrsobotka_at_yahoo.com> wrote in message news:ad8enl$ld1$1_at_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 - 15:35:27 CDT