Skip to Main Content

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!

Where does UTL_MAIL queue emails?

User_XOTKGJun 1 2022

So I'm working on a Dev DB and I need to send emails out with UTL_MAIL. Check the parameters, and I need to set smtp_out_server parameter in the spfile, as it is currently NULL. I set it to my SMTP server, and WHAM: thousands of emails come pouring out to my mail server. So I rush to NULL the parameter out again. But clearly some other developers have been testing UTL_MAIL execution without actually sending anything out.
So my question is, where does Oracle queue mails that are created by UTL_MAIL but cannot be sent because smtp_out_server is incorrectly configured? Because I need to clear that location out before I re-enable the parameter.
Thanks!

This post has been answered by odie_63 on Jun 2 2022
Jump to Answer

Comments

Processing

Post Details

Added on Jun 1 2022
4 comments
904 views