用ORACLE的UTL_SMTP发邮件,在前台测试好好的,同样的语句,一进入SQLPLUS后,来发就报错:
ORA-29279: SMTP permanent error 5.5.4
查了半天,终于在METALINK上找到,这样一篇,试一下,果然Ok,需要加<>括号。
这个看来和PORT有关系,并不是一定出现,原来也是OK的,就今天突然不行,怀疑是当有多个发送MAIL的过程同时启动,可能使用了其他非标准PORT。
Ora-29279: Smtp Permanent Error: 501 Bad Address Syntax Ora-29279
Doc ID: Note:406256.1 Type: PROBLEM
Last Revision Date: 24-SEP-2007 Status: PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 9.0.1.4 to 10.2.0.4
Oracle Server - Personal Edition - Version: 9.0.1 to 10.2.0.3
This problem can occur on any platform.
This problem is generic . It is related to SMTP configuration rather than Database.

This is applicable to any database version.
Symptoms
On 9.x to 10.x :

- Using a stored procedure(s) that uses SMTP to send e-mail.
- When using the port 25 it works fine.
- From Linux, using the port 1025 to send e-mail is successful.
- When using another valid SMTP port, the following error is received :

ORA-29279: SMTP permanent error: 501 Bad address syntax
Changes
The problem is a configuration issue at the SMTP level.
Cause
The SMTP is looking for <> in the address.
Usually e-mail addresses are sent as joe@oracle.com (without brackets), but in this case, SMTP is expecting the angled brackets.

i.e. <joe@oracle.com>

Solution
Change the SMTP configuration to eliminate the looking for <> in the address or modify the code to add the angled brackets before and after the e-mail address.

This issue is not an Oracle issue but one specific to the configuration of the SMTP Server.
ORA-29279: SMTP permanent error 5.5.4
查了半天,终于在METALINK上找到,这样一篇,试一下,果然Ok,需要加<>括号。
这个看来和PORT有关系,并不是一定出现,原来也是OK的,就今天突然不行,怀疑是当有多个发送MAIL的过程同时启动,可能使用了其他非标准PORT。










































