Autonomous Transaction Error 00164 [message #305668] |
Tue, 11 March 2008 08:50  |
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  |
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
|
|
|