SEND Procedure

This procedure is used to add a mail to the mail queue of Application Express. The mail is based on an e-mail template where the placeholder values specified as json string are substituted.

Syntax

PROCEDURE  SEND (
    P_TEMPLATE_STATIC_ID IN VARCHAR2,
    P_PLACEHOLDERS       IN CLOB,
    p_to                 IN VARCHAR2,
    p_cc                 IN VARCHAR2 DEFAULT NULL,
    p_bcc                IN VARCHAR2 DEFAULT NULL,
    p_from               IN VARCHAR2 DEFAULT NULL,
    p_replyto            IN VARCHAR2 DEFAULT NULL,
    p_application_id     IN NUMBER   DEFAULT wwv_flow_security.g_flow_id );

Parameters

Table 24-4 SEND Procedure Parameters

Parameter	Description
`p_template_static_id`	Static identifier string, used to identify the shared component email template.
`p_placeholders`	JSON string representing the placeholder names along with the values, to be substituted.
`p_to`	Valid email address to which the email is sent (required). For multiple email addresses, use a comma-separated list.
`p_cc`	Valid email addresses to which the email is copied. For multiple email addresses, use a comma-separated list.
`p_bcc`	Valid email addresses to which the email is blind copied. For multiple email addresses, use a comma-separated list.
`p_from`	Email address from which the email is sent (required). This email address must be a valid address. Otherwise, the message is not sent.
`p_replyto`	Address of the Reply-To mail header. You can use this parameter as follows: If you omit the p_replyto parameter, the Reply-To mail header is set to the value specified in the p_from parameter If you include the p_replyto parameter, but provide a NULL value, the Reply-To mail header is set to NULL. This results in the suppression of automatic email replies If you include p_replyto parameter, but provide a non-null value (for example, a valid email address), you send these messages, but the automatic replies go to the value specified (for example, the email address)
`p_application_id`	Application ID where the email template is defined. Defaults to the current application (if called from within an application).

Examples

begin
    apex_mail.send (
        p_template_static_id => 'ORDER',
        p_placeholders       => '{ "ORDER_NUMBER": 5321, "ORDER_DATE": "01-Feb-2018", "ORDER_TOTAL": "$12,000" }',
        p_to                 => 'some_user@somewhere.com' );
end;