Email Not Sent Within Application Express, Sending Email Works From Sqlplus
(Doc ID 459362.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Application Express (APEX) - Version 22.214.171.124.7 and later
Information in this document applies to any platform.
A procedure has been created that sends emails using APEX_MAIL.PUSH_QUEUE;. Permission has been granted to PUBLIC, and a process calls this procedure is included in the APEX application. When running the application, emails are not sent out of the Application Express application, and nothing appears in the message queue.
In the same database where APEX is installed, a new schema is set up and own packages are created in it. From SQLPLUS the email can be send
SMTP Host Address: defined
SMTP Host Port:25
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