Problem with UTL_SMTP package (sending emails from ORACLE)

Question

Everything's been working fine and haven't made any changes to our mail packages. But i just noticed that our unsent_emails table has been filling up, and when i tried to manually sent the unsent emails (a periodic job set up in user_jobs) i get the following errors;

Error with main mail package: ORA-29279: SMTP permanent error: 501 5.5.2 MAIL FROM syntax error ORA-06512: at "SYS.UTL_SMTP", line 20
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 221
ORA-06512: at "TRS.MAILPKG", line 63

Any idea why this might be happening?

Answer 1

Are all the unsent emails going out to multiple recipients ?

Here's a link to orafaq that suggests that it might have something to do with sending emails to multiple recipients and using the semicolon - ';' instead of the comma - ',' delimiter.

http://www.orafaq.com/forum/t/119863/2/

If this is the case, then try using a comma as a delimiter for multiple recipients