Oracle Apex - Mail

1 - About

Mail in Apex can be sen with the Apex_Mail package.

3 - API

3.1 - Apex_Mail

The most efficient approach to sending email is to create a background job (using the DBMS_JOB or DBMS_SCHEDULER package) to periodically send all mail messages stored in the active mail queue.

Luckily, this process is normally created during installation with DBMS_SCHEDULER and is named ORACLE_APEX_MAIL_QUEUE. It sends mail that is in the mail queue every 5 minutes.

To call the APEX_MAIL package from outside the context of an Application Express application, you must call apex_util.set_security_group_id.

4 - Configuration

See the APEX_INSTANCE_ADMIN Available Parameter Values that start with SMTP.

  • SMTP_FROM
  • SMTP_HOST_ADDRESS
  • SMTP_HOST_PORT
  • SMTP_PASSWORD
  • SMTP_TLS_MODE
  • SMTP_USERNAME

You can change them in internal

5 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap