Hi All,
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.
I am using apex_mail.send for sending mail and created acl as
BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => 'open_apex.xml');
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'open_apex.xml',
description => 'A test of the ACL functionality',
principal => 'RMSR',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'open_apex.xml',
host => '*',
lower_port => 20,
upper_port => 9999);
COMMIT;
end;
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'open_apex.xml',
principal => 'RMSR',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => NULL,
end_date => NULL);
COMMIT;
END;
It throws error as
ORA-24247: network access denied by access control list (ACL)
Is there any problem in my configuration?
Thanks in Advance,
Su.gi