try using the ip address of the smtp server and not the dns name.
--
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
******************************************
"Magne" <mnam_at_online.no> wrote in message
news:Z1qj9.24632$sR2.437407_at_news4.ulv.nextra.no...
> 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 Mon Sep 23 2002 - 03:11:13 CDT
