Hi guys
I am trying to implement social sign on and it works great if I setup an ACL with the host * rather than login.microsoftonline.com.
Here is my ACL code:
BEGIN
dbms_network_acl_admin.create_acl(acl => 'azure.xml',
description => 'AZURE ACL',
principal => 'APEX_180200',
is_grant => TRUE,
privilege => 'http');
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (acl => 'azure.xml',
host => 'login.microsoftonline.com');
END;
/
If I replace the host with * it works, otherwise I receive the following error.
- ora_sqlerrm: ORA-29273: HTTP request failed
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1017
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1127
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 917
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1523
ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 369
ORA-06512: at "APEX_180200.WWV_FLOW_AUTHENTICATION_NATIVE", line 452
ORA-06512: at "APEX_180200.WWV_FLOW_AUTHENTICATION_NATIVE", line 502
ORA-06512: at "APEX_180200.WWV_FLOW_AUTHENTICATION_NATIVE", line 614
ORA-06512: at "APEX_180200.WWV_FLOW_AUTHENTICATION_NATIVE", line 1685
ORA-06512: at "APEX_180200.WWV_FLOW_PLUGIN", line 2706
ORA-06512: at "APEX_180200.WWV_FLOW_AUTHENTICATION", line 1975
Any ideas?
APEX version 18.2
APEX listener 19.1