ORA-29278: SMTP transient error: 421 Service not available 一般来说,很可能是邮件服务器连接不上 p_conn := utl_smtp.open_connection('xx.xx.xxx.xxx', xxx); 解决方法也很简单,将ip改为正确的邮件服务器ip或者联系服务器运维同事看看是不是对应的端口有问题即可...
followed by a SMTP error code. CAUSE The "ORA-29278: SMTP transient error: 421 Service not available" error indicates that the problem is not with the UTL_SMTP package but the fact that your database server's network configuration does not allow it to contact an external server. SOLUTION Y...