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: Sun Jul 23 01:56:52 CDT 2017

Total time taken to generate the page: 0.14506 seconds