SEND Function Signature 2

This function returns a mail id after adding the mail to the mail queue of Application Express. The mail id can be used in a call to add_attachment to add attachments to an existing mail.

The mail is based on an email template where the placeholder values specified as JSON string are substituted.

Syntax

FUNCTION 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 )
    RETURN NUMBER;

Parameters

Table 30-6 SEND Function 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 function 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

declare
    l_mail_id number;
begin
    l_mail_id := 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' );

    apex_mail.add_attachment (
        p_mail_id    => l_mail_id,
        p_attachment => ... );
end;