Ashton, You can log xml text in TLOG.LTEXTE with all log4plsq features. and use a XML namspace for now the format. Perapse, there is a problem with a size of the message?
About a converting API, you has which prototype thinks? Regards, Guillaume Moulard [EMAIL PROTECTED] Project : LOG4PLSQL : Oracle Database Loggin tools see : http://log4plsql.sourceforge.net/ and : http://sourceforge.net/mailarchive/forum.php?forum=log4plsql-all-info or http://www.mail-archive.com/[EMAIL PROTECTED] for [EMAIL PROTECTED] -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoy� : mardi 17 f�vrier 2004 15:29 � : [EMAIL PROTECTED] Objet : [log4plsql] Log4plsql extension We've been looking at log4plsql for possible use as a standard database logging tool within our organization. We currently have a standard package that we employ, but often find we have to customize it for our different applications. Log4plsql would appear to address a lot of our needs, with one major exception: our database application logging usually employs explicit columns for key value storage; allowing us to join directly in sql from our logging table(s) to staging/load tables etc. The query-ability of these data attributes is crucial to us. Having to parse TLOG.LTEXTE for significant values (e.g. keys, parameter values etc.) would be quite onerous. If I were to customize Log4plsql, I'd consider perhaps another table to store some sort of template for the contents of TLOG.LTEXTE (alternatively add an additional column instead) to accommodate named attributes and a format (xml would be ideal for this). I'd also consider creating an api for converting parameters into the template format, for use prior to calling plog.error/fatal etc. You may already have considered this, or perhaps someone has already suggested it. Might this be something that someone is already working on? Should we endeavor to create this extension ourselves? Your thoughts and comments would be very welcome. Very best regards, Ashton Thorogood Database Team SIG ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id56&alloc_id438&op=click _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
