Re: UTL_MAIL - Trying to find a smtp server that works...

EHLO yerself!

I've done the lower level utl_smtp mail stuff before. I was trying to put 
together asimple demo of ACL's in 11g and trying to use utl_mail which provides 
apretty short and clean example of the whole thing (much cleaner and easier to 
understand than a long utl_smtp example). I've run into thisbefore and I think 
the lack of any ability to configure authenticationwith utl_mail makes it 
almost useless.

BLAH!!!

Thanks for your response though...

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)

----- Original Message ----
From: Dan Norris <dannorris@xxxxxxxxxxxxx>
To: robertgfreeman@xxxxxxxxx
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, March 22, 2008 10:15:54 AM
Subject: Re: UTL_MAIL - Trying to find a smtp server that works...

  EHLO Robert (the smtp geeks probably get that),

I think you'll have to resort to the lower-level SMTP commands toperform the 
necessary authentication from PL/SQL as shown in someexamples at 
http://forums.oracle.com/forums/thread.jspa?messageID=896035

You shouldn't be able to use any ol' SMTP server without authenticationor at 
least SMTP servers shouldn't allow you to use them without somesort of 
authentication (even if just based on an IP range). SMTP serverthat do allow 
you to send mail through them unauthenticated are knownas open mail relays 
(http://en.wikipedia.org/wiki/Open_mail_relay) andare officially Bad Things on 
the internet. Many open relays are used byspammers to send loads of email (to 
me, mostly). As a result, manyblacklists 
(http://en.wikipedia.org/wiki/Mail_Abuse_Prevention_System)have been created to 
help limit the amount of email delivered by theseopen relays. 

So, if you do find an SMTP server willing to accept your messagewithout any 
authentication, there's a fairly decent chance that itwon't end up at its final 
destination unless it's an SMTP server onyour laptop. A search for "free 
windows smtp server" turns up severalhits, but as these are likely to be 
downloaded by spammers (and somepossibly created specifically for that 
purpose), I'm not sure I'd gonear any of them. 

Happy mailing!

Dan

Robert Freeman wrote:    Anyoneknow of an SMTP server that I can use with 
utl_mail? I've tried about 4different ones (e.g. smtp.yahoo.com) that I have 
access too but I geterrors. If I remember correctly this is because many of 
them requireyou include your password (like yahoo mail) and utl_mail does 
notprovide 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)  
  
  
  
--http://www.freelists.org/webpage/oracle-l

Other related posts: