Oracle APEX_MAIL发送给多个收件人
问题描述:
通过APEX_MAIL.SEND向多个收件人发送电子邮件的语法是什么?Oracle APEX_MAIL发送给多个收件人
官方页面,https://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_mail.htm#AEAPI342,说; p_to 电子邮件将发送到的有效电子邮件地址(必填)。对于多个电子邮件地址,请使用逗号分隔列表但是不显示语法示例。
使用他们给出的例子有没有人知道语法?
DECLARE
l_body CLOB;
BEGIN
l_body := 'Thank you for your interest in the APEX_MAIL
package.'||utl_tcp.crlf||utl_tcp.crlf;
l_body := l_body ||' Sincerely,'||utl_tcp.crlf;
l_body := l_body ||' The APEX Dev Team'||utl_tcp.crlf;
apex_mail.send(
p_to => '[email protected]', -- change to your email address
p_from => '[email protected]', -- change to a real senders email address
p_body => l_body,
p_subj => 'APEX_MAIL Package - Plain Text message');
END;
/
答
你只需要把多个逗号分隔的邮件地址为p_to参数。
看到这个例子:
DECLARE
l_body CLOB;
BEGIN
l_body := 'Thank you for your interest in the APEX_MAIL package.'||utl_tcp.crlf||utl_tcp.crlf;
l_body := l_body ||' Sincerely,'||utl_tcp.crlf;
l_body := l_body ||' The APEX Dev Team'||utl_tcp.crlf;
apex_mail.send(
p_to => '[email protected],[email protected]', -- separate multiple recipients with comma
p_from => '[email protected]', -- change to a real senders email address
p_body => l_body,
p_subj => 'APEX_MAIL Package - Plain Text message');
END;
心连心,莫里茨
谢谢,我以前没尝试这个,但我的代码中的另一个错误使它看起来像它不工作。 – BiscuitCookie