To configure and manage email in Oracle Application Express an Instance administrator must log in to Oracle Application Express Administration Services.
Topics:
To enable Oracle Application Express to send email, an Instance administrator must configure email settings. This section describes how to configure email settings in a full development environment and a runtime environment.
Topics:
See Also:
"Configuring Email" in Oracle Application Express Administration Guide
By default, the ability to interact with network services is disabled in Oracle Database 11g Release 1 or 2 or later. Therefore, if you are running Oracle Application Express with Oracle Database 11g Release 1 or 2 or later, you must use the new DBMS_NETWORK_ACL_ADMIN
package to grant connect privileges to any host for the apex_050100
database user. Failing to grant these privileges results in issues with:
Sending outbound mail in Oracle Application Express.
Using Web services in Oracle Application Express.
PDF/report printing.
See Also:
“Enabling Network Services in Oracle Database 11g or Later” for your installation scenario in Oracle Application Express Installation Guide:
"Configuring Email" in Oracle Application Express Administration Guide
To configure Oracle Application Express to send mail in a full development environment your Instance administrator must log in to Oracle Application Express Administration Services, navigate to the Instance Settings page and configure Email attributes.
See Also:
"Configuring Email" in Oracle Application Express Administration Guide
You can configure Oracle Application Express to automatically email users their login credentials when a new workspace request has been approved. To accomplish this, you must complete the email configuration process and select the provisioning status, Request with Email Verification.
See Also:
"Configuring Email" in Oracle Application Express Administration Guide
"About Specifying How Workspaces Are Created" in Oracle Application Express Administration Guide
"Selecting a Provisioning Mode" in Oracle Application Express Administration Guide
Instance administrators can manage email sent from applications by monitoring email messages in the mail queue and mail log.
See Also:
"Managing the Mail Queue" in Oracle Application Express Administration Guide
You can send email from an Oracle Application Express application using the APEX_MAIL
package. 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_MAIL.
See Also:
"APEX_MAIL" in Oracle Application Express API Reference
"Configuring Email" in Oracle Application Express Administration Guide