Re: How to send e-mail to the administrator on triggering events

In article <pf99ntsfh2gln7s4sl7diev6jvfftrmb6g_at_4ax.com>, Dino says...
>
>On Fri, 10 Aug 2001 20:18:20 GMT, techsup_at_mindspring.com (James
>Williams) wrote:
>
>>On Sat, 11 Aug 2001 00:14:30 +0800, Dino Hsu <dino1_at_ms1.hinet.net>
>>wrote:
>>
>>Put in s separate proc a call to utl_smtp if you are at 8.1.6 or
>>higher. Documented in the Oracle supplied packages manual.
>>
>>>Dear all,
>>>
>>>Oracle 8i offers enhanced triggering events such as alter, create,
>>>drop, logoff, logon, servererror, shutdown, startup. How do I make
>>>Oracle send e-mail to me on these triggering events. I probably want
>>>to know about any server errors. Any comments are highly appreciated.
>>>
>>>Dino
>>>
>
>Are you really sure to use utl_smtp? Notice it's name is 'SMTP', not
>'mail', don't you think it's too low level to send e-mail with just
>SMTP protocol support? How do you format your e-mail contents? We are
>no experts of SMTP protocol, we are just database administrators who
>want the warning messages to be sent as e-mail.
>

the documentation he pointed you to:

http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/utl_smt6.htm#1001075

has everything you need, a procedure called "send_mail"

>Thanks anyway,
>Dino
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp