Outbound Email Delivery From APEX Seems To Stall (Stuck)
(Doc ID 2057872.1)
Last updated on AUGUST 23, 2023
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Application Express (APEX) - Version 4.2.6 and later
Information in this document applies to any platform.
Symptoms
On : 4.2.6 version, Administration
ACTUAL BEHAVIOR
---------------
Emails seems to be enqueued and not sent or sent very slowly (few at a time)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Send an email inside apex using code similar to:
2 Is possible to send emails using localhost instead of remote SMTP IP address
3 ACL is granted to APEX (apex_040200) schema but NOT to SYS
Changes
Nothing on Apex or Database side that user are aware of.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |