PUSH_QUEUE Procedure

Oracle Application Express stores unsent email messages in the APEX_MAIL_QUEUE dictionary view. You can manually deliver mail messages stored in this queue to the SMTP gateway by invoking the APEX_MAIL.PUSH_QUEUE procedure.

Application Express logs successfully submitted messages in the APEX_MAIL_LOG dictionary view with the timestamp reflecting your server's local time.

Syntax

APEX_MAIL.PUSH_QUEUE(
    p_smtp_hostname             IN    VARCHAR2 DEFAULT NULL,
    p_smtp_portno               IN    NUMBER   DEFAULT NULL);

Parameters

Table 29-4 PUSH_QUEUE Parameters

Parameters	Description
`p_smtp_hostname`	SMTP gateway host name
`p_smtp_portno`	SMTP gateway port number

Note that these parameter values are provided for backward compatibility, but their respective values are ignored. The SMTP gateway hostname and SMTP gateway port number are exclusively derived from values entered on the Instance Settings page in Administration Services or set using APEX_INSTANCE_ADMIN API.

Example

The following example demonstrates the use of the APEX_MAIL.PUSH_QUEUE procedure using a shell script. This example only applies to UNIX/LINUX installations.

SQLPLUS / <<EOF
APEX_MAIL.PUSH_QUEUE;
DISCONNECT
EXIT
EOF