Skip to Main Content

APEX

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!

APEX_MAIL and opening and closing SMTP connections

CaribbeanUserApr 7 2021

Hi,
When using UTL_SMTP to send an email, one has to open a connection to the SMTP server and after having sent the email, issue a QUIT. APEX_MAIL.send, on the other hand, queues the email in an APEX queue. A separate job in APEX dequeues the messages and actually sends the queued emails. My question is the following, suppose I have number of emails in the queue, does the aforementioned job open a connection to the SMTP server once, sends all the queued emails, and then quits, or will the job do an open/send/quit for every email in the queue?
Any help would be greatly appreciated,
Regards,
Abraham

This post has been answered by fac586 on Apr 9 2021
Jump to Answer
Comments
Post Details
Added on Apr 7 2021
8 comments
480 views