Re: DBMS_JOB, Distributed transactions and logging.

From: Alex Vilner <alex_at_sinoma.com>
Date: 24 Sep 2002 11:37:30 -0700
Message-ID: <22e9f6e0.0209241037.751328d4@posting.google.com>

Vladimir,

Thank you for your reply (Spasibo!) -- the issue is that PRAGMA AUTONOMOUS_TRANSACTION is not allowed on the remote side of the distributed transaction, and this is precisely where we want to do the logging...

--Alex

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<altdj6$m0h$1_at_babylon.agtel.net>...
> Research autonomous transactions. You can write a generic error log
> procedure that you will call in exception handler, and this procedure
> will log error in an autonomous transaction and commit it (while the
> outer transaction may rollback at will). To declare a procedure
> transaction scope autonomous you use
> PRAGMA AUTONOMOUS_TRANSACTION
> in procedure declaration block.
>
> hth.
>
> --
> Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Received on Tue Sep 24 2002 - 13:37:30 CDT