我用的是263的企业邮箱,用ORACLE存储过程发邮件,总是报:ORA-29279: SMTP permanent error: 598 mail is rejected
请问大侠怎么弄?
CREATE OR REPLACE PROCEDURE send_mail(
subject in VARCHAR2,
message in VARCHAR2,
recipient in VARCHAR2
)
IS
sender VARCHAR2(200) :='[email protected]';
mailhost VARCHAR2 (30) := 'smtp.YY.com.cn';
mail_conn utl_smtp.connection;
crlf VARCHAR2 (2) := CHR (13)
|| CHR (10);
mesg VARCHAR2 (1000);
BEGIN
mail_conn := utl_smtp.open_connection (mailhost, 25);
mesg := 'Date: '
|| TO_CHAR (SYSDATE, 'dd Mon yy hh24:mi:ss')
|| crlf
|| 'From: '
|| crlf
|| 'Subject: '
|| subject
|| crlf
|| 'To: '
|| recipient
|| crlf
|| ''
|| crlf
|| message;
utl_smtp.ehlo (mail_conn, mailhost);--身份验证已经改成ehlo了
utl_smtp.mail (mail_conn, sender);
utl_smtp.rcpt (mail_conn, recipient);
utl_smtp.data (mail_conn, mesg);
utl_smtp.quit (mail_conn);
exception
when others then
dbms_output.put_line(sqlerrm);
END;
|