Email Not Sent Within Application Express, Sending Email Works From Sqlplus
Last updated on NOVEMBER 14, 2016
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms