I am about to implement Log4plsql on a couple of databases. What I would really like to have is the ability to automatically send an email whenever a certain message level is logged (e.g. Fatal or Error). I cannot use the connection to Log4j, however, because of internal policy restrictions. Has anyone considered using the Oracle utl_smtp package in conjunction with Log4plsql ?
Also, instead of fixed email recipient parameters specified in the package spec, I'm thinking of creating an admin_contact type of table that would contain the names and email addresses of the various administrators for the databases and applications. That table would contain fields that state who is the current support contact versus the backup support contacts (i.e. the current contact would be the "From" recipient, and the backups would be "CC" recipients), and possibly which schemas they are responsible for. Just some ideas. Brad ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net
