Re: UTL_MAIL - Trying to find a smtp server that works...
From: Dan Norris <dannorris_at_dannorris.com>
Date: Sat, 22 Mar 2008 11:15:54 -0500
Message-ID: <47E530BA.9070007@dannorris.com>
I think you'll have to resort to the lower-level SMTP commands to perform the necessary authentication from PL/SQL as shown in some examples at http://forums.oracle.com/forums/thread.jspa?messageID=896035
You shouldn't be able to use any ol' SMTP server without authentication or at least SMTP servers shouldn't allow you to use them without some sort of authentication (even if just based on an IP range). SMTP server that do allow you to send mail through them unauthenticated are known as open mail relays (http://en.wikipedia.org/wiki/Open_mail_relay) and are officially Bad Things on the internet. Many open relays are used by spammers to send loads of email (to me, mostly). As a result, many blacklists (http://en.wikipedia.org/wiki/Mail_Abuse_Prevention_System) have been created to help limit the amount of email delivered by these open relays.
So, if you do find an SMTP server willing to accept your message without any authentication, there's a fairly decent chance that it won't end up at its final destination unless it's an SMTP server on your laptop. A search for "free windows smtp server" turns up several hits, but as these are likely to be downloaded by spammers (and some possibly created specifically for that purpose), I'm not sure I'd go near any of them.
Happy mailing!
Dan
Robert Freeman wrote:
Date: Sat, 22 Mar 2008 11:15:54 -0500
Message-ID: <47E530BA.9070007@dannorris.com>
EHLO Robert (the smtp geeks probably get that),
I think you'll have to resort to the lower-level SMTP commands to perform the necessary authentication from PL/SQL as shown in some examples at http://forums.oracle.com/forums/thread.jspa?messageID=896035
You shouldn't be able to use any ol' SMTP server without authentication or at least SMTP servers shouldn't allow you to use them without some sort of authentication (even if just based on an IP range). SMTP server that do allow you to send mail through them unauthenticated are known as open mail relays (http://en.wikipedia.org/wiki/Open_mail_relay) and are officially Bad Things on the internet. Many open relays are used by spammers to send loads of email (to me, mostly). As a result, many blacklists (http://en.wikipedia.org/wiki/Mail_Abuse_Prevention_System) have been created to help limit the amount of email delivered by these open relays.
So, if you do find an SMTP server willing to accept your message without any authentication, there's a fairly decent chance that it won't end up at its final destination unless it's an SMTP server on your laptop. A search for "free windows smtp server" turns up several hits, but as these are likely to be downloaded by spammers (and some possibly created specifically for that purpose), I'm not sure I'd go near any of them.
Happy mailing!
Dan
Robert Freeman wrote:
-- http://www.freelists.org/webpage/oracle-l Received on Sat Mar 22 2008 - 11:15:54 CDTAnyone know of an SMTP server that I can use with utl_mail? I've tried about 4 different ones (e.g. smtp.yahoo.com) that I have access too but I get errors. If I remember correctly this is because many of them require you include your password (like yahoo mail) and utl_mail does not provide for this.
Any suggestions?
RF
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)