You can use the
APEX_MAIL package to send an email from an Oracle Application
Express application. This package is built on top of the Oracle-supplied
UTL_SMTP package. Because of this dependence, the
UTL_SMTP package must be installed and functioning to use
APEX_MAILcontains three notable procedures:
APEX_MAIL.SENDto send an outbound email message from your application.
APEX_MAIL.PUSH_QUEUEto deliver mail messages stored in
APEX_MAIL.ADD_ATTACHMENTto send an outbound email message from your application as an attachment.
Application Express installs the database job
ORACLE_APEX_MAIL_QUEUE, which periodically sends all mail messages stored in the active mail queue.
APEX_MAIL package may be used from outside the context of an Application Express application (such as from SQL*Plus or from a Database Scheduler job) as long as the database user making the call is mapped to an Application Express workspace. If the database user is mapped to multiple workspaces, you must first call
APEX_UTIL.SET_SECURITY_GROUP_ID as in the following examples. The
APEX_MAIL package cannot be used by database users that are not mapped to any workspace unless they have been granted the role
- Example 1 apex_util.set_workspace(p_workspace => 'MY_WORKSPACE'); -- Example 2 FOR c1 in ( select workspace_id from apex_applications where application_id = 100 ) LOOP apex_util.set_security_group_id(p_security_group_id => c1.workspace_id); END LOOP;
For more information about the UTL_SMTP package, see Oracle Database PL/SQL Packages and Types Reference
Sending Email from an Application in Oracle Application Express App Builder User’s Guide