SEND Procedure Signature 2

This procedure adds a mail to the mail queue of Application Express. The mail is based on an email 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 apex_application.g_flow_id );

Parameters

Table 31-8 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).

Note:

When calling the SEND procedure from outside the context of an Application Express application (such as from a Database Scheduler job), you must specify the p_application_id parameter.

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;