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

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Sat, 11 Aug 2001 11:31:24 +0800
Message-ID: <pf99ntsfh2gln7s4sl7diev6jvfftrmb6g@4ax.com>

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.

Thanks anyway,
Dino Received on Fri Aug 10 2001 - 22:31:24 CDT