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!

utl_http and https connection

344384Apr 18 2012 — edited Apr 19 2012
I m trying to call a https webapi which is hosted on suppliers server.

I have successfully called webapis before from pl/sql and it has worked, i.e soap request and soap response.

But in this case as its https, i m unable to and it just throws exception. I was told that I would need a oracle wallet configured.
select utl_http.request('https://support.oracle.com/CSP/ui/flash.html','uname:pwd@proxy.abc.uk:8080') from dual
The above code raises an error

but this code works fine for me
select utl_http.request('http://www.google.co.uk','uname:pwd@proxy.abc.uk:8080') from dual
For the https to work, do i need to have oracle wallet configured and then give the wallet location and password in the utl_http.request parameters.

Is that what is required, btw, my oracle version is
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production                           
CORE   9.2.0.6.0   Production                                       
TNS for Solaris: Version 9.2.0.6.0 - Production                 
NLSRTL Version 9.2.0.6.0 - Production  
Any inputs appreciated,

Thanks

Srini
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2012
Added on Apr 18 2012
12 comments
2,012 views