Re: PL/SQL EMail Question

David A. Gershman wrote:
>
> Is there a way for PL/SQL to 'send out' an email?
>
> i.e. in UNIX a text file created with headers can be sent on its way by the command:
>
> % sendmail -t < mail_message.txt
>
> Is there PL/SQL way of doing the same?
Oracle would offer you the Interoffice product to do this.

If you want to send emails at a regular interval, an alternative is to use UTL_FILE to write out an operating system file and to have cron job look for this file and send it on.

-- 
_____________________________________________________________

Opinions expressed are my own and do not reflect my employers