Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX send email，denied by ACL

wanglei_CNJan 12 2020 — edited Jan 12 2020

Hello everyone.

 oracle db 19C  + APEX 19.2

 I want to send email in my apps.But I can't make it,please give me some advice.

 Thanks for any help.
  1. I run this pl/sql refer to the Oracle APEX 19.2 Guide.

BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => '*', ace => xs$ace_type(privilege_list => xs$name_list('connect'), principal_name => 'APEX_190200', -- I have changed it to my schema,you can see next picture principal_type => xs_acl.ptype_db)); END; /

 2. then I check the acl privilege,it seems like no error.

pastedImage_6.png

 3. and then I configure my email server:

pastedImage_7.png

 4. finally I got ACL error when I attempt to send test email,I can find them in Mail Queue,just can't send.

ORA-24247: network access denied by access control list (ACL)

pastedImage_8.png

Comments

Processing

Post Details

Added on Jan 12 2020
#apex-discussions
2 comments
818 views