Oracle® Web Application Programming for PL/SQL® Developers

Unit 19.1. Sending Electronic Mail From an Oracle Database

If you’d like to send email from PL/SQL applications and from an Oracle database, you can use the UTL_SMTP package. This package follows the Simple Mail Transfer Protocol (SMTP) standards. SMTP is the Internet’s standard protocol for email. SMTP serves as an Application Programmer Interface (API) to SMTP mail systems. Since Oracle’s UTL_SMTP package uses SMTP standards, you are given the ability to call its functions or procedures to send email directly from the database. You can use PL/SQL to construct your email message text, and easily incorporate information retrieved from the database. You will need to know the name or IP address of the SMTP mail server used by the sender, as well ...