Re: send mail from database

Bullshit Remco! Since 8.0 it is perfectly possible to call external programs from the RDBMS and since 8.1
to implement java classes.
Dus aan het werk joh, lees de nieuwe manuals! 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 - 21:56:32 CEST