This is an example of using PL/SQL to send plain text email from Oracle database using UTL_SMTP. For this to work, the database should be configured for SMTP (along with related Java classes/ JVM ). The UTL_SMTP package is designed for SMTP communication specified by IETF RFC-821. 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. |
74001