UTL_SMTP and RFC 821/RFC 2821
570854Jun 26 2009 — edited Oct 29 2009This may be picky since most modern mail servers are relaxed, but when using utl_smtp.mail and utl_smtp.rcpt the address needs to be enclosed in pointy brackets.
utl_smtp.mail( connection, '<me@someaddress.com>');
utl_smtp.rcpt( connection, '<other@somewhereelse.com>');
I ran into this problem sending mail to an older Exchange server.
Oracle's documentation doesn't explicitly say it, but from what I've seen utl_smtp.mail and utl_smtp.rcp translate directly to the SMTP commands "MAIL FROM: " and "RPCT TO: " without any interpretation. The grammar in RFC 821 shows it, and RFC 2821 explicitly says it, the path must always be enclosed in pointy brackets.
Again most mail servers are relaxed on this issue, but I found at least one that isn't.
Edited by: hip on Jun 26, 2009 12:28 PM
Edited by: hip on Jun 26, 2009 12:28 PM