admin管理员组文章数量:1642349
使用Oracle UTL_SMTP包測試發送MAIL
SQL> DECLARE
2 l_mailhost VARCHAR2(64) := '???.???.???.???';
3 l_from VARCHAR2(64) := 'FROMMAIL@XXXX.COM';
4 l_to VARCHAR2(64) := 'TOMAIL@XXXX.COM';
5 l_mail_conn UTL_SMTP.connection;
6 BEGIN
7 l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);
8 UTL_SMTP.helo(l_mail_conn, l_mailhost);
9 UTL_SMTP.mail(l_mail_conn, l_from);
10 -- UTL_SMTP.rcpt(l_mail_conn, l_to); -- UNCOMMENT THIS LINE
11 UTL_SMTP.data(l_mail_conn, 'Single string message.' || Chr(13));
12 UTL_SMTP.quit(l_mail_conn);
13 END;
14 /
DECLARE
l_mailhost VARCHAR2(64) := '???.???.???.???';
l_from VARCHAR2(64) := 'FROMMAIL@XXXX.COM';
l_to VARCHAR2(64) := 'TOMAIL@XXXX.COM';
l_mail_conn UTL_SMTP.connection;
BEGIN
l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);
UTL_SMTP.helo(l_mail_conn, l_mailhost);
UTL_SMTP.mail(l_mail_conn, l_from);
--UTL_SMTP.rcpt(l_mail_conn, l_to); -- UNCOMMENT THIS LINE
UTL_SMTP.data(l_mail_conn, 'Single string message.' || Chr(13));
UTL_SMTP.quit(l_mail_conn);
END;
ORA-29279: SMTP permanent error: 503 5.5.2 Need Rcpt command.
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 273
ORA-06512: at "SYS.UTL_SMTP", line 249
ORA-06512: at "SYS.UTL_SMTP", line 260
ORA-06512: at line 11
REFER:http://www.oracle-base/articles/9i/EmailFromPLSQL9i.php
本文标签: SMTPpermanentORAErrorRcpt
版权声明:本文标题:ORA-29279: SMTP permanent error: 503 5.5.2 Need Rcpt command. 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dianzi/1729334715a1196828.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论