RE: sending email

Ruth,

I saved your attachment to C: drive and then openned it using Notepad, and the following text is inside the file:

        <encoded content removed -- binaries not allowed by ListGuru>

Appranetly you attached a binary file and the List did not allow it.

Long

-----Original Message-----
From: guy ruth hammond [mailto:grh_at_agency.com] Sent: Thursday, April 27, 2000 9:59 PM
To: Multiple recipients of list ORACLE-L Subject: Re: sending email

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