Re: E-Mails
Date: 1996/08/12
Message-ID: <177E1978F.ASVLH_at_TJUVM.TJU.EDU>#1/1
Uwe Harmening asks:
> is it possible to send email messages in the internet out of a pl/sql
> procedure? We have Oracle 7.2 for Windows NT.
> Any suggestions are welcome.
Since Windows NT is posix-compliant, it should support unix's "mail" command:
mail my_account_at_host.domain.com < email_msg
If "email_msg" is a text file terminated by an EOF character, the "mail"
command will send the file to the specified address. This command uses
the less-than sign to redirect input to the desired file. If this works
from Windows NT, you should be able to do the same thing from PL/SQL by
using the 'host' command to pass the mail command to the operating
system:
host mail my_account_at_host.domain.com < email_msg;
Unfortunately, I haven't played with NT yet, and I'd like to know if this works for you. Good luck!
- Lance