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

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