Re: How to call Unix SendMail from Oracle?

Not sure what you need to get done, but if all you need to do is send some e-mails every so often, an easy yet powerful way is to write a script in perl (With the DBD and DBI module) that connects to the database, figures out what e-mails need to be constructed, build the messages and then use the system command to execute sendmail for each message. You can then run this as a cron every hour, day, or whatever interval you want. You could also do this in a Pro*C program if you don't like perl

If you want to create a trigger and/or procedure in the database that send e-mail when it fires that's more work because you would have to code an external procedure in C that you would call from PL/SQL, so unless you absolutly need a PL/SQL procedure or trigger solution, it would be less work to use the perl solution.

Ron Bogdanoff
Sr. Software Engineer
Digital Market Inc.

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.
>
>

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