Here is what I’m trying to do:
SELECT utl_http.request('openexchangerates.org',NULL,'file:C:/Users/Uchih/OneDrive/Escritorio/wallet','password123') from dual;
I need to make a http.request, to test a connection to that web site to use a webservice from that page.
And also I already have configured my wallet with all the certificates of the web page.
So the wallet shouldn’t be a problem
And here is my acl code:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => 'otro_acl.xml',
description => 'otra prueba',
principal => 'APEX_220200',
is_grant => TRUE,
privilege => 'connect'
);
END;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'otro_acl.xml',
principal => 'APEX_220200',
is_grant => TRUE,
privilege => 'resolve'
);
END;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'otro_acl.xml',
host => 'openexchangerates.org',
lower_port => NULL,
upper_port => NULL
);
END;
Also I assigned te privileges to my hr user:
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'otro_acl.xml',
principal => 'HR',
is_grant => TRUE,
privilege => 'connect'
);
END;
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
acl => 'otro_acl.xml',
principal => 'HR',
is_grant => TRUE,
privilege => 'resolve'
);
END;
But I’m getting these errors:
ORA-29273: fallo de la solicitud HTTP
ORA-06512: en "SYS.UTL_HTTP", línea 1530
ORA-28759: fallo al abrir el archivo
ORA-06512: en "SYS.UTL_HTTP", línea 651
ORA-06512: en "SYS.UTL_HTTP", línea 1472
ORA-06512: en línea 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.