This is an example of using PL/SQL to send plain text
email from Oracle
using UTL_SMTP. For this to work, the database
should be configured for
(along with related
). The UTL_SMTP package is designed for SMTP communication
For the example below, the actual SMTP mail server name
has to be used (l_mailhost). The code can be enhanced to
send mail with file attachments. The other PL/SQL utility
function is UTL_MAIL.
Oracle registered trademark of Oracle Corporation.