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