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?
the problem was because of my "from" email (looked into it thanks to Bob Jarvis).. it didn't look like an email address (which have worked before but i think there were some changes to the email server which makes it not work now)