Sending e-mail from Oracle PL/SQL stored procedures

The README file is included below, and download oraclemail-0.7.tar.gz here. This is a tarred and gzipped file for Unix systems. You'll need gzip (gnu zip) to unpack it (available from your nearest GNU mirror) and tar.

And it probably won't compile very well on non-Unixlike systems, because I use functions like pipe(), and fork(). A port to one of those other systems would be welcome.

I only develop for Unix because I consider Windows an unstable platform. I am not aware of a port to NT of this software or any comparable software available for NT. Please do not mail me asking for such a version, I will put it on this page when I get notified of such a product existing. (and for people interested in porting it to NT: I get this question a lot)

Simple solution for sending mail from a stored procedure in Oracle.

Usable for sending mail from oracle web applications.

The GNU General Public License is included but it only applies to
oraclemaildaemon.pc and oraclemailclient.sql

Original code for oraclemaildaemon.pc and oraclemailclient.sql by 
Don Browne available from

Modifications to his code (for security reasons) by Koos van den Hout.

smtp.c is written by Wietse Venema


This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.



* Edit the Makefile. Compiler options are set for Solaris, and the
username/password for connecting to oracle needs to be filled in.

* Edit oraclemaildaemon.pc to use the same username/password and set
the location where smtp is installed.

* Compile smtp.c and install it in a safe place in your webserver.

* Compile oraclemaildaemon and install it too.

* Run oraclemailclient.sql from svrmgrl/sqldba for the account you want
to use it from, this will install the package 'mail'.



* oraclemaildaemon runs waiting for connections from oracle processes.

* See testmail.sql for a sample on how to use this.


                                  Koos van den Hout
                                  Developer new media

Koos van den Hout ( )