Re: ORA-00164

From: Boaz Laufer <lauferb_at_adit-tec.com>
Date: 1 Jun 2002 12:49:44 -0700
Message-ID: <1bacd337.0206011149.4eb1457a@posting.google.com>

"Petr Sobotka" <petrsobotka_at_yahoo.com> wrote in message news:<ad88q8$eh6$1_at_av2.rz.fh-augsburg.de>...
> Can anybody explain me the following error message (it doesn't exist in the
> Oracle manual):
>
> ORA-00164: autonomous transaction disallowed within distributed transaction
>
> I get it when calling a procedure in another DB server.
>
> Thanks,
> Petr

Does the username that calls the procedure from one database exists on the other database and has 'execute any procedure' privilege?

Boaz. Received on Sat Jun 01 2002 - 14:49:44 CDT