ORA-29278: SMTP transient error: 421 Service not available while calling utl_smtp,close_data
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 ?