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!