Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to call Unix SendMail from Oracle?

Re: How to call Unix SendMail from Oracle?

From: Diane <Diane_at_coalole.demon.co.uk>
Date: Thu, 1 Jul 1999 20:44:15 +0100
Message-ID: <lBoyWCAPU8e3IwJS@coalole.demon.co.uk>


In article <7leceq$uii$1_at_nnrp1.deja.com>, student <ennaadu_at_my-deja.com> writes
>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.
we use this method and it works very well --
Diane Received on Thu Jul 01 1999 - 14:44:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US