How to create network ACL in oracle apex?

Login to your database as a dba & run the below code.

BEGIN
  DBMS_NETWORK_ACL_ADMIN.append_host_ace (
    host       => 'api.docparser.com',
    lower_port => NULL ,
    upper_port => NULL ,
    ace        => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
                              principal_name => 'YOURSCHEMA_USERNAME',
                              principal_type => xs_acl.ptype_db));
END;

Comments

Popular posts from this blog

FTP integration in oracle apex