Re: How to call Unix SendMail from Oracle?

From: student <ennaadu_at_my-deja.com>
Date: Thu, 01 Jul 1999 00:24:04 GMT
Message-ID: <7leceq$uii$1@nnrp1.deja.com>

In article <377A5AF5.95C00A2B_at_compuserve.com>,   John Haskins <76054.334_at_compuserve.com> wrote:
> Greetings:
>
> I need to initiate e-mail sends from my Oracle 7.3.3.5.0 system.
> We do not have the Oracle*Mail program, so it looks like I need to
> call the Unix server's SendMail routine. Can anyone here give me
> an overview (or details) on how to do this?
>
> Thanks.
>
>

  Hi john,
    you can spool the message content into a file.use the 'host' command from pl/sql script to call the sendmail/mailx utility. The spool file can be deleted using the same host command after the mail being sent. May not be the best solution, but it works..

EN Nadu

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 19:24:04 CDT