Re: send mail from database

Hi there,

Yes, you will have to send to an SMTP server. Where I work, we run shell scripts on AIX and VMS to extract the addresses and then send them to SMTP. On AIX we simply use sendmail and on VMS it is a system call to the SMTP procecess. On NT you would have to install a similar mail daemon to perform the same thing.

"S. van Hoof" wrote:

> Hi,
>
> Running NT4 SP6, WEBDB2.2, ORA7.3.4.
>
> I want to set up a system which collects questions from people and sends
> them answers via email.
> Therefore I have created a table containing mail-adresses and questions.
>
> Lets say every our I want to send emails to new questions. I want to create
> a 'batch' file containing mail-adresses every hour. PLSQL may do this for
> me.
>
> I wonder how I can send the emails in the file?
> Can I send the file (in a certain format) to a smtp-server?
> Do I have to set up a smtp-server myself (we are connected to the net)?
>
> Other suggestions are very welcome...
>
> Stephan
Received on Mon Apr 17 2000 - 02:04:33 CEST