I would suggest using the logging to table feature, and put a custom trigger on the table to send email when your desired criteria are met. For performance, you may want to batch the outgoing messages into a different table, and have a scheduled job check for new messages to send, since sending mail can take some time (up to several seconds, depending on the mail server and load).
Greg Woolsey Sabrix, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 8:21 AM To: [EMAIL PROTECTED] Subject: [log4plsql] Integration with utl_smtp 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=ick _______________________________________________ Log4plsql-all-info mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info log4plsq : http://log4plsql.sourceforge.net ------------------------------------------------------- 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
