Re: UTL_MAIL - Trying to find a smtp server that works...
Date: Thu, 27 Mar 2008 10:42:24 -0700
since it's a demo...
Why not setup an SMTP server that requires no authentication on the same box that is running your db? You can configure the SMTP server to only accept connections from localhost so it doesn't get flooded with spam requests.
choices: sendmail, exim, qmail to name a few
That's what I use in my tiny lab at home....
Robert Freeman wrote:
> Anyone 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?
> Robert G. Freeman
> 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)