PL/SQL (MOSC)

MOSC Banner

ORA-29278: SMTP transient error: 421 Service not available while calling utl_smtp,close_data

edited Aug 10, 2020 5:00AM in PL/SQL (MOSC) 10 commentsAnswered
Hello All

 I got the error ORA-29278: SMTP transient error: 421 Service not available while calling utl_smtp,close_data(l_connection) in a procedure to send html mail. I have done some troubleshooting. I was able to succesfully connect to the exchange via a telnet session from the database server. I registered the client and sent some data information which was ended with a dot and quited.
This confirm to me that communication could be established between the exchange and the DB OS. I also tried suing a simple procedure to send text mail ( Please see first attachment) and the mail went successfully. The issue I have is with sending HTML mail using the procedure attached. It establishes connection , set the to, from and other smtp parameters, was able to write data but hangs after a call to utl_smtp.close_data and eventually returned an exception "ORA-29278: SMTP transient error: 421 Service not available". How can I resolve this issue ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center