File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling web service with a url

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.

I have a web service that I need to call from pl sql. Previously it was done by adding parameters to the url for the web service and using utl_http package
ie

Then I would parse that response

Now after migrating to weblogic, this has been returning a not found error.

So I added the wsdl for the service to a soapUI project, and passed the value. It worked fine there, so the web service seems to be up and functioning.

Here is the basic xml for the request:

So assuming the wsdl for that is:

http://webservice.com/service_name?wsdl

is there a way for me to invoke with parameters? (maybe the params need to be altered somewhat - how would I find out what the new ones are? I have tried looking at the wsdl but have not figured it out using that)

I have never invoked a web service in this manner, so I am not entirely sure what is causing it to fail after the weblogic migration

Thanks


 
Ivan Krizsan
Ranch Hand
Posts: 2198
1
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
Have you seen this? http://akdora.wordpress.com/2007/08/03/calling-a-web-service-by-plsql-utl_http/
Best wishes!
 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ivan,

I actually used exactly that. I knew about that way of doing it from previous usage. It was just that the code was already built in another way, so changing it to that method would have meant more code change than may have been necessary. I wanted to try to get it done by just changing the url. Turns out, with the weblogic migration, the web service no longer has an endpoint (at least an interface for one). So that was not an option anymore.

Thanks very much for the help though!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic