Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to call Unix SendMail from Oracle?
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
![]() |
![]() |