Well then, take a look at DBMS_PIPE. I think it is possible to run a listening
session on remote site that will pick up messages from the pipe which remote
procedures (running locally on that site) will post and log them independently.
Never tried this myself, but I have a gut feeling that it should work.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Alex Vilner" <alex_at_sinoma.com> wrote in message
news:22e9f6e0.0209241037.751328d4_at_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 Wed Sep 25 2002 - 07:46:14 CDT
