18.1 Sending Email from an Application

To configure and manage email in Oracle Application Express an Instance administrator must log in to Oracle Application Express Administration Services.

Topics:

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

Topics:

See Also:

"Configuring Email" in Oracle Application Express Administration Guide

18.1.1.1 About Enabling Network Services

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:

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

18.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:

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

18.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: