[log4plsql] Log4plsql extension

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

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.=20

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
610.747.2392=20



IMPORTANT: The information contained in this email and/or its =
attachments is confidential. If you are not the intended recipient, =
please notify the sender immediately by reply and immediately delete =
this message and all its attachments.  Any review, use, reproduction, =
disclosure or dissemination of this message or any attachment by an =
unintended recipient is strictly prohibited.  Neither this message nor =
any attachment is intended as or should be construed as an offer, =
solicitation or recommendation to buy or sell any security or other =
financial instrument.  Neither the sender, his or her employer nor any =
of their respective affiliates makes any warranties as to the =
completeness or accuracy of any of the information contained herein or =
that this message or any of its attachments is free of viruses.