19 Sending Email from APEX

To enable sending email from APEX, you must have access to an SMTP server. Only Oracle’s OCI SMTP server is supported. To send mail, you will need to provide values for the following Application Properties (see Section 7.19.6 “Application Properties” for details on setting property values).

To enable sending email from APEX, you must have access to an SMTP server. Only Oracle’s OCI SMTP server is supported. To send mail, you will need to provide values for the following Application Properties (see the Application Properties in the Retail DB Ops Console chapter for details on setting property values).

oracle.apex.setting.smtp_host_address
oracle.apex.setting.smtp_username
oracle.apex.setting.smtp_password
oracle.apex.setting.smtp_host_port
oracle.apex.setting.smtp_from

Your settings can be verified by sending a test email by clicking the Send a Test Mail button (see the figure below). Once you have verified your settings, you can use the APEX_MAIL package to send emails from Oracle APEX applications.

The APEX_MAIL_QUEUE will contain any queued email messages. The APEX_MAIL_LOG will contain the disposition of sent mail. Specifically, it will indicate whether an email message was sent successfully or not. See APEX_MAIL package documentation for additional details.

Note:

To send email from your RDS ADW instance using the APEX_MAIL package, you must provision an OCI SMTP server. Only Oracle’s OCI SMTP server is supported for sending email from RDS ADW.

Figure 19-1 Sending a Test Email