Home » SQL & PL/SQL » SQL & PL/SQL » Autonomous Transaction Error 00164 (8.1.7.4)
Autonomous Transaction Error 00164 [message #305668] Tue, 11 March 2008 08:50 Go to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I know that the combination of autonomous and distributed transactions were not fully supported until 9.2, and I'm in an 8.1.7.4 environment.

But does anyone know of problems where this error will be raised even when you are not doing a distributed transaction? I've got some plsql procedures that are autonomous, and this error is being raised back to the client (Java / Tomcat).

ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction.

But, these procedures are doing nothing distributed. Does anyone know of any bugs or problems where this error will be raised in error? Or any advice related to solving such an issue?
Re: Autonomous Transaction Error 00164 [message #305699 is a reply to message #305668] Tue, 11 March 2008 10:27 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm pretty sure that you can't have an autonomous transaction in a distributed transaction even in r9.2.

Try having a look at the v$dblink view at the point where the error happens - that should show you for certain if there is a Db link involved in the transaction
Previous Topic: how to modify the view
Next Topic: Group by Error
Goto Forum:
  


Current Time: Thu Feb 06 16:14:41 CST 2025