Re: sending email

This is a multi-part message in MIME format.

--------------E5A3037EDCB467D9A8C7D559
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Kevin Martin wrote:
>
> Hi list.
>
> Is it possible for Oracle to send email notification when a specified event
> occurs? I haven't found anything in the docs that describes this, and I
> really don't want to reinvent the wheel if I can avoid it.

Hello,

I've attached a snippet of Pro*C (for Solaris, should work on most Unix variants) for listening on a DBMS_PIPE and sending the output using SMTP (the Internet email standard).

g

-- 
guy ruth hammond <grh_at_agency.com> | "Wade in with our workboots,
Technology / Synergy / Consulting |    try to finish the job."
07879607148 http://www.agency.com |      -- Dar Williams
--------------E5A3037EDCB467D9A8C7D559
Content-Type: application/x-unknown-content-type-pc_auto_file;
 name="mail_pipe.pc"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
 filename="mail_pipe.pc"

<binary content removed -- do not send binaries to the list>

--------------E5A3037EDCB467D9A8C7D559--