TR: [Log4plsql] dbms_pipe vs autonomus_transaction

[<log...@li...>]

Hi,

Yes, is correct.

And there is one proposition without dbms_pipe of the package
by Dan Catalin.


G.


 -----Message d'origine-----
De : log...@li... =
[mailto:log...@li...]
Envoy=E9 : mardi 18 mars 2003 00:08
=C0 : log...@li...
Objet : [Log4plsql] q: regarding transaction log off


Hi  ,
is it correct that you've choosen to use dbms_pipe instead of pragma =
automuns_transaction to be more generic ?=20

(if you have the answer i'm a mailing list  , a appolgize for the =
repeating question )



-----Message d'origine-----
De : log...@li...
[mailto:log...@li...]
Envoy=E9 : mercredi 13 novembre 2002 00:18
=C0 : log...@li...
Objet : RE: [Log4plsql] dbms_pipe vs autonomus_transaction


It seems to me more clear and easy to use and ... I saw some other =
requests for this.
Please find the changes attached.

changes:
renamed DEFAULT_USE_PIPE to DEFAULT_LOG_OFF_TRAN
renamed all USE_PIPE occurrences to LOG_OFF_TRAN

removed background* functions

added two private procedures
addRow
addRowAutonomous

changed log function to check LOF_OFF_TRAN
and to call addRow or addRowAutonomous.
=20

Please let me know if this is OK.
If not I can make the changes you suggest.

Should I add also other functions like isDebugEnabled()
which exists in log4j?

Thank you very much for your time.

Dan Catalin

-----Original Message-----
From: log...@li...
[mailto:log...@li...]
Sent: Tuesday, November 12, 2002 06:27 AM
To: log...@li...
Subject: RE: [Log4plsql] dbms_pipe vs autonomus_transaction


Bonjour,=20

I think : Why not.

why your prefere autonomus_transaction versus dbms_pipe?

Cordialement / Regards,=20
Guillaume Moulard=20


> -----Message d'origine-----
> De : log...@li...
> [mailto:log...@li...]
> Envoy=E9 : vendredi 8 novembre 2002 21:15
> =C0 : log...@li...
> Objet : [Log4plsql] dbms_pipe vs autonomus_transaction
>=20
>=20
> Would be nice to be able to set how to log (using dbms_pipe=20
> or autonomus_transaction).
>=20
> If the concern is 7.x does does not support this=20
> it would be nice to specify the version=20
> at the instalation time andthe install script will create the package=20
> with or without autonomus_transaction procedure in place.
> What do you think?
>=20
> Most of the times people nee to log outside of the current=20
> transaction=20
> and in the database, so the autonomus_transaction will be ok.
>=20
> Catalin
>=20
>=20
>=20
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm=20
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> Log4plsql-all-info mailing list
> Log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
> log4plsq : http://log4plsql.sourceforge.net