Re: UTL_SMTP : 421 Service not available ?

From: Jan Schäfer <schaefer_at_imise.uni-leipzig.de>
Date: Tue, 4 Dec 2001 10:47:08 +0100
Message-ID: <9ui62s$lv0$1@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 Tue Dec 04 2001 - 03:47:08 CST