Skip to Main Content

SQL & PL/SQL

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!

Oracle error “ORA-28759: failure to open file” when requesting utl_http package

Ali AsgorNov 5 2014 — edited Nov 5 2014

I can't execute following statement-

DECLARE

lo_req UTL_HTTP.req;

lo_resp UTL_HTTP.resp;

BEGIN

UTL_HTTP.SET_WALLET ('file:C:\app\wallet','abcd@1234');

lo_req := UTL_HTTP.begin_request('https://wordpress.org/');

lo_resp := UTL_HTTP.get_response(lo_req);

dbms_output.put_line(lo_resp.status_code);

UTL_HTTP.end_response(lo_resp);

END;


My wallet path is C:\app\wallet and password is abcd@1234.
When execute this code, display following error:

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

How can I solve that?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2014
Added on Nov 5 2014
0 comments
881 views