Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP" ORA-28759: failure to open file

User_3EQMGSep 1 2020

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;

Comments
Post Details
Added on Sep 1 2020
0 comments
2,991 views