smtp email

[bcrawford]

Has anyone worked with utl_smtp to send an email from a pl/sql block? I am getting connection errors when I tried to execute the procedure.

What kind of smtp config do i need to do on the server?

Thanks,

[sreddy]

http://www.samoratech.com/Topicofinterest/swHowtoSendMail.htm

[TimHall]

This works in Oracle8i and Oracle9i:

http://www.oracle-base.com/Articles/9i/EmailFromPLSQL9i.asp

This works fine using the SendMail service in UNIX and Linux and the basic SMTP service in Windows NT4/2000. No extra configuration needed.