Sending e-mail from an Oracle database with utl_smtp

If you're running Oracle 10g or later, you can use the nice modern utl_mail package to send e-mails from your PL/SQL applications. Even though the application I maintain is now running on Oracle 10g, it was built back on an Oracle 8i database, so it sends e-mails via the older (and more complicated) utl_smtp package.

The article continues at http://www.builderau.com.au/program/oracle/soa/Sending-e-mail-from-an-Oracle-database-with-utl-smtp/0,339028441,339284343,00.htm