41.7 PUSH_QUEUE Procedure
This procedure manually delivers queued mail messages stored in the APEX_MAIL_QUEUE
dictionary view to the SMTP gateway.
Oracle APEX 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 41-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.
sql / <<EOF
APEX_MAIL.PUSH_QUEUE;
DISCONNECT
EXIT
EOF
See Also:
- Configuring Email in Oracle APEX Administration Guide
- Sending an Email from an Application in Oracle APEX App Builder User’s Guide
Parent topic: APEX_MAIL