Forum Stats

  • 3,734,740 Users
  • 2,247,033 Discussions
  • 7,857,477 Comments

Discussions

ORA-30678: too many open connections apex_mail email stuck in queue

tfa
tfa Member Posts: 406 Bronze Badge
edited Jul 30, 2020 2:13PM in APEX Discussions

Currently using apex 18.2 on 11G database.

Issue I've encountered is we have a user that submitted a process that tried to send ~1000 emails via apex_mail.send procedure.  All emails in that batch and a few others encountered error:  ORA-30678: too many open connections.  Those emails are stuck in the queue and will not be sent regardless of APEX_MAIL.PUSH_QUEUE being executed to send them.

New emails arriving in queue are being sent but no emails that have had errors can be sent.  As I understand the error ORA-30678 it's a capacity error and not an error specific with the format or setup of the individual email records.

How can those emails that currently have the ORA-30678 error associated to them be retried and sent from queue?

Regards,

Todd

Best Answer

Answers

Sign In or Register to comment.