Email Not Sent Within Application Express, Sending Email Works From Sqlplus
(Doc ID 459362.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Application Express (formerly HTML DB) - Version 188.8.131.52.7 and later
Information in this document applies to any platform.
*** Checked for relevance on 15-May-2012***
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!