Re: send mail from database

Sorry Remco, I did not see Stephan was using Oracle 7! In that case you were right of course.
Remco Moolenaar <remco_at_scc.nl> schreef in berichtnieuws 38F8ABF4.A9B6E7A9_at_scc.nl...
> "S. van Hoof" wrote:
>
> > I wonder how I can send the emails in the file?
>
> Create a Windows program which will query the database and sends the
questions
> to a SMTP server. Unfortunately, Oracle does not have tools to call
external
> programs from the RDBMS. The closest Oracle gets to this is with the
DBMS_PIPES
> stuff.
> The Windows program is probably easier, because IDE's (like with C++
Builder)
> will contain an SMTP class.
>
> > Can I send the file (in a certain format) to a smtp-server?
>
> Yes, any server will do.
>
> > Do I have to set up a smtp-server myself (we are connected to the net)?
>
> No, you can use the one from your provider.
>
> --
> Remco Moolenaar mailto:remco_at_scc.nl
> SCC Internetworking & Databases http://www.scc.nl/
> Amsterdam, The Netherlands mailto:remco_at_bsdapps.org
>
> Maintainer of the BSD Applications database at http://www.bsdapps.org/
>
>
Received on Sat Apr 15 2000 - 22:09:39 CEST