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!

HTTPS Webservice calling UTL_HTTP

675307Jan 26 2010 — edited Mar 2 2010
Hi All,

I am trying to call a webservice using UTL_HTTP. The service is hosted as HTTPS. I have taken the following steps,

1. Saved the SSL certificate to a folder.
2. Created a new wallet using Oracle Wallet Manager.
3. Imported the above certificate in the wallet.
4. Saved the wallet to F:\My_Wallet.

Now when I execute the code it gives me the following error,

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1029
ORA-28759: failure to open file
ORA-06512: at "SCOTT.SOAP_CALL", line 21
ORA-06512: at line 1

The wallet folder only has ewallet.p12 file.

Kindly help.

Thanks

Rap.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2010
Added on Jan 26 2010
2 comments
2,200 views