[log4plsql] Integration with utl_smtp
Brought to you by:
gmoulard
From: <log...@li...> - 2004-03-23 16:20:47
|
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 |