PL/SQL (MOSC)

MOSC Banner

HTTP Call error: ORA-24247 Network access denied

in PL/SQL (MOSC) 4 commentsAnswered

I am using Oracle DB 19.10.0.0.0 with EBS 12.1.3 Facing below error when trying to call an http request:

ORA-24247 Network access denied by access control list.

I reviewed Doc ID 1074843.1 but couldn't find any clue about issue. I used below command to create ACL.

BEGIN

 DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

 host     => 'google.com', lower_port => 443, upper_port => 443,

 ace     => xs$ace_type(privilege_list => xs$name_list('http'),

               principal_name => 'APPS',

               principal_type => XS_ACL.PTYPE_DB));

END;

Note: calling google.com is a test which clarifies that there is no issue in accessing external urls. Also I used http privilege instead of connect or resolve as per

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center