19.1 Sending Email from an Application

This section describes how to configure and manage email in Oracle Application Express.

19.1.1 About Configuring Email

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.

See Also:

"Configuring Email" in Oracle Application Express Administration Guide

19.1.1.1 About Enabling Network Services

If you are running Oracle Application Express with Oracle Database 11g or later, you must enable outbound mail. Starting with Oracle Database 11g Release 1 (11.1), the ability to interact with network services is disabled by default.

By default, the ability to interact with network services is disabled in Oracle Database 11g or later. Therefore, if you are running Oracle Application Express with Oracle Database 11g or later, you must use the DBMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for the APEX_050000 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" for your configuration scenario in Oracle Application Express Installation Guide and "Configuring Email" in Oracle Application Express Administration Guide

19.1.1.2 About Configuring Email in a Full Development Environment

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

19.1.2 About Email Provisioning

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," "About Specifying How Workspaces Are Created" and "Selecting a Provisioning Mode" in Oracle Application Express Administration Guide

19.1.3 About the Mail Queue

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

19.1.4 About the APEX_MAIL Package

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 and "Configuring Email" in Oracle Application Express Administration Guide