Home » SQL & PL/SQL » SQL & PL/SQL » Autonomous Transaction Error 00164 (
Autonomous Transaction Error 00164 [message #305668] Tue, 11 March 2008 08:50 Go to next message
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 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
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: Wed Oct 26 11:09:58 CDT 2016

Total time taken to generate the page: 0.06328 seconds