I entered the same adress as i use in my mail-client.....
The strange thing is that if i execute the procedure
UTL_SMTP.OPEN_CONNECTION directly (from Toad) it says Procedure completed,
but if i do a call to this procedure from another procedure it returns the
error....
and the error occour immediate. so it doens't look like it is searching for
an adress...
..and jserver is installed..
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3d8e2130$0$8513$cc9e4d1f_at_news.dial.pipex.com...
> "Magne" <mnam_at_online.no> wrote in message
> news:oloj9.21155$0p1.374967_at_news2.ulv.nextra.no...
> > Hi
> >
> > Someone who knows what to do to be able to send email from Oracle
(version
> > 8.1.7)?
> >
> > I have created a procedure with call to the UTL_SMTP package...
> > But if i test my procedure it only returns an error:
> > ORA-20001: 421 Service not available
>
> 421 service not available is an SMTP error message (saying that the smtp
> service is not available). The most likely cause of this is that you
haven't
> set the smtp server address correctly.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>
Received on Sun Sep 22 2002 - 15:50:01 CDT
