utl_smtp.rcpt(mail_conn,'[email protected]'); mesg:= 'text'; utl_smtp.data(mail_conn,mesg); utl_smtp.quit(mail_conn); END; ORA-29279: SMTP permanent error: 501 strangeness between : and < ORA-06512: at "SYS.UTL_SMTP", line 17 ORA-06512: at "SYS.UTL_SMTP", line 98 ORA-06512: at "SYS.UTL_SMTP", line 221 ORA-06512: at line 8this error occurs at the .mail callWhat is it trying to tell me with between : and <When I telnet this IP it responds initially but that's itThe mail server is notes/dominany help is appreciated.
Followup: Well, thats not a database error -- that is the SMTP server being finicky. RFC 821 states that all envelope information should be enclosed in angle brackets. try putting <> about your email addresses.
ORA-29279 这个错,一般是你设置smtp参数不对,或你的机器,有限制,无法连到smtp server
utl_smtp.command(l_connection,
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(YourEmailID))));
utl_smtp.command(l_connection,
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(YourEmailPassword))));
mailhost varchar2(30) := '999.11.2.99' ;
mail_conn utl_smtp.connection;
mesg varchar2(4000);
begin
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn,'[email protected]');
utl_smtp.rcpt(mail_conn,'[email protected]');
mesg:= 'text';
utl_smtp.data(mail_conn,mesg);
utl_smtp.quit(mail_conn);
END; ORA-29279: SMTP permanent error: 501 strangeness between : and <
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 221
ORA-06512: at line 8this error occurs at the .mail callWhat is it trying to tell me with between : and <When I telnet this IP it responds initially but that's itThe mail server is notes/dominany help is appreciated.
Followup:
Well, thats not a database error -- that is the SMTP server being finicky. RFC 821 states that all envelope information should be enclosed in angle
brackets. try putting <> about your email addresses.
这个错,一般是你设置smtp参数不对,或你的机器,有限制,无法连到smtp server