Re: UTL_SMTP : 421 Service not available ?

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Wed, 5 Dec 2001 09:14:13 +0100
Message-ID: <9uklkv$dv2$1@news4.isdnet.net>

Hi,

I tried what you kindly suggested, but the return message is always the same :
'service not available'.

I checked again the parameters of my mail account in Outlook express, I think if got the right parameters. here's what i tried, may be you'll see something wrong...

SQL> declare

  2      mail_conn utl_smtp.connection;
  3      return_message utl_smtp.reply;

  4 begin
  5 return_message := utl_smtp.open_connection('195.3.3.6',25,mail_conn);   6 dbms_output.put_line(return_message.text);   7 return_message := utl_smtp.helo(mail_conn, '195.3.3.6');   8 dbms_output.put_line(return_message.text);   9 end;
 10 /
Service not available
Service not available

PL/SQL procedure successfully completed.

Thanks.

Yann

Jan Schäfer a écrit dans le message <9ui62s$lv0$1_at_news.uni-leipzig.de>...
>> I tried to send a mail using our provider, it doesn't work, sending
>message
>> :
>>
>> ORA-20001: 421 Service not available
>> ORA-06512: at "SYS.UTL_SMTP", line 83
>> ORA-06512: at "SYS.UTL_SMTP", line 344
>
>Just try to get the messages from the mail server of your provider by
>calling the utl_smtp commands like this:
>
>declare
> mail_conn utl_smtp.connection;
> return_message utl_smtp.reply;
> .
> .
>
>begin
> return_message := utl_smtp.open_connection('mailhost', 25, mail_conn);
> message(return_message);
> return_message := utl_smtp.helo(mail_conn, 'mailhost');
> message(return_message);
> .
> .
>end;
>
>This will give you more information when and probably why it doesn't work.
>
>So long,
>
>Jan
>
>
Received on Wed Dec 05 2001 - 02:14:13 CST