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

  • 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 attempting to send a test email by clicking on the ‘Send a Test Mail’ button. 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.

Figure 19-1 Send Test Email


Send Test Email