admin管理员组

文章数量:1642331

使用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://m.elefans.com/dianzi/1729334715a1196828.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。