19.1 Sending Email from an Application
To configure and manage email in Oracle APEX, an Instance administrator must sign in to APEX Administration Services.
- About Configuring Email
To enable APEX to send email, an Instance administrator must configure email settings. - About Email Provisioning
Learn about email provisioning. - About the Mail Queue
Learn about the mail queue. - About the APEX_MAIL Package
Learn about theAPEX_MAIL
package.
Parent topic: Extending Application Capabilities
19.1.1 About Configuring Email
To enable APEX to send email, an Instance administrator must configure email settings.
- About Enabling Network Services
Learn about enabling network services. - About Configuring Email in a Full Development Environment
Learn about about configuring email in a full development environment.
See Also:
Configuring Email in Oracle APEX Administration Guide
Parent topic: Sending Email from an Application
19.1.1.1 About Enabling Network Services
Learn about enabling network services.
Enabling network services enables support for sending outbound mail in Oracle APEX, use of Web services in Oracle APEX, and PDF report printing.
By default, the ability to interact with network services is
disabled in Oracle Database 11g Release 2 or later. Therefore, if you are running Oracle APEX with Oracle Database 11g Release 2 or later, you must use the new
DBMS_NETWORK_ACL_ADMIN
package to grant connect privileges to any host for
the APEX_220200
database user. Failing to grant these privileges results in
issues with:
-
Sending outbound mail in Oracle APEX.
Users can call methods from the
APEX_MAIL
package, but issues arise when sending outbound email. -
Using Web services in Oracle APEX.
-
PDF/report printing.
See Also:
- Enabling Network Services in Oracle Database in Oracle APEX Installation Guide
-
Configuring Email in Oracle APEX Administration Guide
Parent topic: About Configuring Email
19.1.1.2 About Configuring Email in a Full Development Environment
Learn about about configuring email in a full development environment.
To configure APEX to send mail in a full development environment your Instance administrator must sign in to APEX Administration Services, navigate to the Instance Settings page, and configure Email attributes.
See Also:
Configuring Email in Oracle APEX Administration Guide
Parent topic: About Configuring Email
19.1.2 About Email Provisioning
Learn about email provisioning.
To configure APEX 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 APEX Administration Guide
- About Specifying How Workspaces Are Created in Oracle APEX Administration Guide
- Selecting a Provisioning Mode in Oracle APEX Administration Guide
Parent topic: Sending Email from an Application
19.1.3 About the Mail Queue
Learn 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 APEX Administration Guide
Parent topic: Sending Email from an Application
19.1.4 About the APEX_MAIL Package
Learn about the APEX_MAIL
package.
You can send email from an APEX application using the APEX_MAIL
package.
The APEX_MAIL
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 APEX API Reference
- Configuring Email in Oracle APEX Administration Guide
Parent topic: Sending Email from an Application