Hi - just checking if anyone has managed to get utl_http successfully calling a secure site, on 10g R2 Windows, as I've hit something of a brick wall with it.
I've followed the steps in this article:
http://www.idevelopment.info/data/Oracle/DBA_tips/PL_SQL/PLSQL_19.shtml
In summary I've..
- downloaded the certificate(s) from my target site.
- in wallet manager, Imported Trusted Certs to add them to a wallet
- saved wallet, confirmed the ewallet.p12 file is created.
- added the set_wallet line to my code, triple checking the password is correct.
But when I run the code, I can't get past this error:
declare
w clob;
begin
utl_http.set_wallet('file:c:\wallet', 'wallet123');
w:=utl_http.request('https://xxxxxxxxxxxxxxx.asmx');
dbms_output.put_line(w);
end;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-28759: failure to open file
ORA-06512: at line 5
The user I'm running the code as can access the c:\wallet folder, I've created a directory and tested writing a file there.
from some googling I've also tried setting the wallet to Auto Login in owm, which creates a cwallet.sso file in the wallet dir. Didn't resolve the issue though, with or without the password parameter.
I've also seen reference to adding the wallet location to the sqlnet.ora file, but can't find a definitive answer on whether this is necessary.
Has anyone else hit this error, and by any chance come up with a solution?
thanks in advance.