ORA-00164 during PL/SQL execution

[slicendice]

Hi
I am running a PL/SQL package that uses a database link to obtain data from a table in another database for processing. The code also has a procedure for logging messages/errors/etc to a log table that uses the PRAGMA AUTONOMOUS TRANSACTION directive - this enables messages that are written to the log table to be made permanent whilst still allowing a ROLLBACK by the calling proc if there is an error.
When I run the code, I get the error:

ORA-00164: autonomous transaction disallowed within distributed transaction

I understand from searching the web that this is a problem on Oracle 8.1.7 (which is what I'm using) when using autonomous transactions at the same time as using database links. What I've not been able to find is if there are any workarounds/fixes for this problem - does anyone know of any?

Failing that, is there an alternative way of writing msgs/errors to a log table without using AUTONOMOUS TRANSACTION?

Many thanks

 

[sem]

We use DBMS_PIPE package and a job listening for messages. IMO asynchronous processing is much more reliable.

Regards, Dima

http://seminihin.narod.ru

 

[slicendice]

Thanks sem

I'll check out DBMS_PIPE