Re: UTL_SMTP : 421 Service not available ?

Just one slight suggestion:

when you issue utl_smtp.helo(), you should generally specify the IP or domain name of the host that connects to the server, not that of the SMTP server itself or just some fake string. Some servers do validation of HELO parameters and deny access if domain name and/or IP address specified by the sender do not match actual values the server got when it accepted the connection (this is done to prevent spam through the server).

PSP_Mail, our Oracle8i emailing solution built around UTL_SMTP, allows you to avoid this and many other issues with the many different versions of SMTP servers out there, plus it allows to send e-mails with LOB attachments, can detect recipient's email server and send directly to it, provides NLS support for both message body and headers allowing you to send e-mails in your native language which are fully conformant to MIME standard, and more.

You can try it out for free by downloading an evaluation copy from http://www.dpsp-yes.com, and it's fairly priced if you decide it is of help to you.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message
news:9ukr1v$nl6$1_at_news5.isdnet.net...


> You were right, the mail is sent from the server, and the server was not

> able to connect to the router.

> This point has been cleared, and now it's OK.

>

> Many thanks for your help.

>

> Yann

>

> Jan Schäfer a écrit dans le message <9ukps5$jr2$1_at_news.uni-leipzig.de>...

> >"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> schrieb im Newsbeitrag

> >news:9ukp3r$rs4$1_at_news2.isdnet.net...

> >> I tried to send a mail using telnet, and the same commands than used with

> >> oracle (helo,...), it works fine.

> >

> >I assume that you've done this from your workstation. So the firewall will

> >let you do this either you use the command line or other tools. But the

> >e-mails from the database are sent from the database sever. If there is a

> >deny-rule on the firewall for port 25 for the database server no mailing

> >will be possible...

> >

> >> I wonder if there is not something to activate into Oracle to send mails.

> >> May be the message 'Service not available' is sent by Oracle and not by

> >the

> >> provider ?

> >

> >But you've sent mail internally. So it works in principle.

> >

> >Hope that helps...

> >

> >Jan

> >

> >

>

>