Email Not Sent Within Application Express, Sending Email Works From Sqlplus (Doc ID 459362.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.0.1.0.7 and later
Information in this document applies to any platform.
*** Checked for relevance on 15-May-2012***


Symptoms

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

Email
SMTP Host Address: defined
SMTP Host Port:25

Cause

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