O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required