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 -> HELP! : ORA-00164: autonomous transaction disallowed within distributed transaction

HELP! : ORA-00164: autonomous transaction disallowed within distributed transaction

From: Kevin <fourad_at_email.com>
Date: 22 Aug 2002 03:27:25 -0700
Message-ID: <eb4ad078.0208220227.775a8f6f@posting.google.com>


Greetings All,

I'm facing a strange problem resulting in the error below:

ORA-00164: autonomous transaction disallowed within distributed transaction

The call which resulted in this error is

     select get_next_seqno('?','?') as seq_no from dual

where 'get_next_seqno' is a function that access table x and returns a varchar2. Due to the current architecture we're adopting, we have no way but to call a function from a select statement.

The funny thing is that this call used to work perfectly before the database (Oracle 8.1.7) was moved from server A to B(with exactly the same server/database configuration).

Before the move, the stored procedure was stored in server A and it was accessing table x in server B. Now, the stored procedure is still in server A, but accessing the table within the same server.

I've read several postings that mentioned that this could be due to a call being made to a remote stored procedure. However, in this situation, the call is made locally and I can't figure out why it isn't working.

Can anone provide any help/info/pointers as to where I might have gone wrong?

Regards,
Kevin Received on Thu Aug 22 2002 - 05:27:25 CDT

Original text of this message

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