I am creating an application using Oracle Apex 5.
I have one button call Send Mail and mail is worked.
Now i have imported my application in another schema and configured acl as below.
It throws error as
ORA-24247: network access denied by access control list (ACL)
Is there any problem in my configuration?
You have granted the ACL to RMSR schema of your database, also it is required for APEX_050000 schema when using APEX_MAIL package.
Here is why ACL should be granted to APEX 5 schema: https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29161
Here is the how the ACL should be granted for APEX 5 schema: https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29162
- Create the ACLs by connecting to SYS user with SYSDBA privileges.
- Do not forget to commit after the executing the anonymous block for creating ACLs.