Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMTP and RFC 821/RFC 2821

570854Jun 26 2009 — edited Oct 29 2009
This 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2009
Added on Jun 26 2009
7 comments
1,949 views