SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with UTL_SMTP package

789255Sep 27 2010 — edited Oct 27 2010

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?

This post has been answered by james m on Sep 27 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2010

Added on Sep 27 2010

#email, #oracle

7 comments

830 views