Hi,
I am using APEX 21.1.0 on oracle XE 18.0.0.0.0, I am trying to send email from APEX using mailtrap.io service.
I gave APEX schema required ACL and configured SMTP as below.
The problem is that all emails stuck in the Mail Queue and not sent to mail server nor giving me any error.
Is there any chance to know where is the problem or how can I resolve this issue?
--- ACL
BEGIN
DBMS_NETWORK_ACL_ADMIN.DROP_ACL(ACL => 'mydba.xml');
DBMS\_NETWORK\_ACL\_ADMIN.CREATE\_ACL(ACL => 'mydba.xml', **DESCRIPTION** => 'SMTP, MAIL, HTTP Access', PRINCIPAL => 'APEX\_210100', IS\_GRANT => **TRUE**, **PRIVILEGE** => 'connect', START\_DATE => **NULL**, END\_DATE => **NULL**);
DBMS\_NETWORK\_ACL\_ADMIN.ASSIGN\_ACL(ACL => 'mydba.xml', **HOST** => '\*', LOWER\_PORT => **NULL**, UPPER\_PORT => **NULL**);
DBMS\_NETWORK\_ACL\_ADMIN.ADD\_PRIVILEGE(ACL => 'mydba.xml', PRINCIPAL => 'MY\_APEX\_USER', IS\_GRANT => **TRUE**, **PRIVILEGE** => 'connect', START\_DATE => **NULL**, END\_DATE => **NULL**);
DBMS\_NETWORK\_ACL\_ADMIN.ADD\_PRIVILEGE(ACL => 'mydba.xml', PRINCIPAL => 'MY\_APEX\_USER', IS\_GRANT => **TRUE**, **PRIVILEGE** => 'resolve', START\_DATE => **NULL**, END\_DATE => **NULL**);
**COMMIT**;
END;
/
-- APEX Email configuration
-- Code used to send email
APEX_MAIL.SEND(P_TO => 'test@gmail.com', P_FROM => 'test@test.com', P_BODY => 'My Email Body.', P_SUBJ => 'Mail subject');
APEX_MAIL.PUSH_QUEUE;
