Home » SQL & PL/SQL » SQL & PL/SQL » Getting SMTP error
Getting SMTP error [message #198618] Wed, 18 October 2006 00:35 Go to next message
Messages: 56
Registered: October 2005
Location: hyderabad
Hi all,

I am trying to send email from pl/sql by using util.smtp pkg.

getting the following error:

-29278 ORA-29278: SMTP transient error: 421 Service not available

PL/SQL procedure successfully completed.

but SMTP server is up and running fine.

any other services required to up in local system?
what might be the reason for getting this error?

Thanks in advance,
Re: Getting SMTP error [message #198632 is a reply to message #198618] Wed, 18 October 2006 01:12 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Some questions:
  1. Oracle version?
  2. How are you executing the procedure (sql*plus, TOAD, ...)
  3. Are you using a dedicated server? (check tnsnames.ora)
  4. Are you connecting with the correct authentication information?

Previous Topic: ora-12560: TNS: protocol adapter error
Next Topic: can any one?
Goto Forum:

Current Time: Sat Oct 22 08:46:40 CDT 2016

Total time taken to generate the page: 0.30567 seconds