RE: [log4plsql] Integration with utl_smtp

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

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: log...@li...
[mailto:log...@li...]=20
Sent: Tuesday, March 23, 2004 8:21 AM
To: log...@li...
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_id=1470&alloc_id638&op=3Dick
_______________________________________________
Log4plsql-all-info mailing list Log...@li...
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net