Alguien me puede ayudar. Necesito acceder a un servidor web desde Windows pero al momento de consumirlo el servicio tengo el siguiete error:
-ORA-29273: HTTP request failed
-ORA-06512: at "SYS.UTL_HTTP"
-ORA-28759: failure to open file
Mi código es:
declare
l_acl_name varchar2(100) := 'utl_http_demo.xml';
begin
dbms_network_acl_admin.create_acl(acl => l_acl_name,
description => 'Acceso UTL for demo',
principal => 'DEMO',
is_grant => true,
privilege => 'connect',
start_date => null,
end_date => null);
dbms_network_acl_admin.add_privilege(acl => l_acl_name,
principal => 'DEMO',
is_grant => true,
privilege => 'resolve',
start_date => null,
end_date => null);
dbms_network_acl_admin.assign_acl(acl => l_acl_name,
host => '*.google.com',
lower_port => null,
upper_port => null);
DBMS_NETWORK_ACL_ADMIN.ASSIGN_WALLET_acl(acl => l_acl_name,
wallet_path => 'file:C:\app\demo_\product\18.0.0\dbhomeXE\owm\wallets\demo_');
end;
Test:
DECLARE
lo_req UTL_HTTP.req;
lo_resp UTL_HTTP.resp;
BEGIN
UTL_HTTP.set_wallet(('file:C:\app\demo_\product\18.0.0\dbhomeXE\owm\wallets\demo_',
'mypass#666'));
lo_req := UTL_HTTP.begin_request('https://www.google.com/');
lo_resp := UTL_HTTP.get_response(lo_req);
dbms_output.put_line(lo_resp.status_code);
UTL_HTTP.end_response(lo_resp);
END;