This forum is currently locked. You can't register or post questions at this time. (read more)

https webservice

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Srinivas
Senior Member
Posts: 185
Joined: Mon Nov 08, 2004 10:14 am
Location: UK

https webservice

Postby Srinivas » Wed Apr 18, 2012 12:36 pm

Hi Tim

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.

Code: Select all

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

Code: Select all

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

Code: Select all

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: https webservice

Postby Tim... » Wed Apr 18, 2012 12:53 pm

Hi.

I know HTTPS is possible and I do believe you need a wallet to accomplish it, but I've never needed to use it when calling a public web service, so I've never investigated it. I guess you need to ask the question on the OTN forum to see if anyone else has done it.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Srinivas
Senior Member
Posts: 185
Joined: Mon Nov 08, 2004 10:14 am
Location: UK

Re: https webservice

Postby Srinivas » Wed Apr 18, 2012 12:58 pm

Thanks very much tim,

Shall post in the OTN and see if anyone has done this before

Srini

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: https webservice

Postby Tim... » Wed Apr 18, 2012 1:04 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: https webservice

Postby Tim... » Mon May 07, 2012 10:49 am

Hi.

I had to do something similar today and I wrote this:

http://www.oracle-base.com/articles/mis ... nd-ssl.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 4 guests