Send an email using utl_smtp of Oracle. The same statement is tested on the front-end. When SQL plus is entered, an error is returned:
ORA-29279: SMTP permanent error 5.5.4
After checking for half a day, I finally found it on Metalink. For such an article, try it. It is OK and you need to add <> brackets.
This seems to have something to do with port, not necessarily appeared. It turned out to be OK. Today it suddenly didn't work. I suspect that when multiple mail sending processes are started at the same time, other non-standard ports may be used.
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:
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 wrongly Ed:
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 a 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.
