Oracle Apex - Mail

Card Puncher Data Processing

About

Mail in Apex can be sen with the apex_mail package.

API

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.

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

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Apex - (Security Group|Workspace Id) (Apex Context)

The security group id is the workspace id. Setting the security group id specify the workspace. It is especially useful when: you want to use an APEX function outside Apex (ie in the database) (Thanks...



Share this page:
Follow us:
Task Runner