create or replace procedure email ( p_email in varchar2) is l_workspace_id number; l_subject varchar2(2000); l_body clob; l_body_html clob; l_email varchar2(40); begin l_workspace_id := apex_util.find_security_group_id (p_workspace => 'xyz'); apex_util.set_security_group_id (p_security_group_id => l_workspace_id); l_email:= p_email; l_body := ' '; l_subject := 'You have new tasks'; --if l_email=:P3_CONFIRM_EMAIL_ADDRESS is not null then -- email( l_email =>:P3_CONFIRM_EMAIL ); -- end if; l_body_html := '<p/>The following tasks have been added.'; apex_mail.send ( p_to => l_email , p_from => 'email@example.com', p_body => l_body, p_body_html => l_body_html, p_subj => l_subject ); APEX_MAIL.PUSH_QUEUE; end;
Both the queries has my TEST email but it not pushing the queue out
select * from apex_mail_queue select * from apex_mail_log
Hunk09 wrote:It is obvious that it was failing with the above error. Google that error or even search the form you will find loads of results.
ORA-24247: network access denied by access control list (ACL)