declare

–works for testing, but is not secure to leave in place…
–lc_principal constant varchar2(30) := ‘PUBLIC’;
–lc_host constant varchar2(100) := ‘*’;

lc_principal constant varchar2(30) := ‘your-application-schema-name-here’;
lc_host constant varchar2(100) := ‘api-verify.recaptcha.net’;

begin

–Uncomment if recreating…
–dbms_network_acl_admin.drop_acl(‘recaptcha.xml’);

dbms_network_acl_admin.create_acl(acl => ‘recaptcha.xml’,
description => ‘Recaptcha Validation ACL’,
principal => lc_principal,
is_grant => true,
privilege => ‘connect’);

dbms_network_acl_admin.add_privilege(acl => ‘recaptcha.xml’,
principal => lc_principal,
is_grant => true,
privilege => ‘resolve’);

dbms_network_acl_admin.assign_acl(acl => ‘recaptcha.xml’,
host => lc_host,
lower_port => 80,
upper_port => 80);
commit;

end;