BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => ‘http_access.xml’,
description => ‘HTTP Access’,
principal => ‘SCHEMA_NAME’, — Reemplaza ‘SCHEMA_NAME’ con el esquema del usuario que ejecuta el procedimiento
is_grant => TRUE,
privilege => ‘connect’
);
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => ‘http_access.xml’,
principal => ‘SCHEMA_NAME’, — Reemplaza ‘SCHEMA_NAME’ con el esquema del usuario que ejecuta el procedimiento
is_grant => TRUE,
privilege => ‘resolve’
);
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => ‘http_access.xml’,
host => ‘tu_url’, — El host de la URL
lower_port => 8100, — El puerto de la URL
upper_port => 8100 — El puerto de la URL
);
END;

COMMIT;

SELECT * FROM DBA_NETWORK_ACLS;
SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES;

ORA-29273: HTTP request failed
ORA-06512: at “SYS.UTL_HTTP”, line 1530
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 1470
ORA-06512: at line 1
29273. 00000 – “HTTP request failed”
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.