Calling web service with a url

[Matt Kohanek]

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

v_response_pieces := utl_http.request_pieces('http://webservice.com/service_name/context_root?invoke=methodName&passedParam=value');  

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:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:two="http://com/job/app/export/export.wsdl">
   <soap:Header/>
   <soap:Body>
      <two:methodName>
         <passedParam>ACDC</passedParam>
      </two:methodName>
   </soap:Body>
</soap:Envelope>

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]

Hi!
Have you seen this? http://akdora.wordpress.com/2007/08/03/calling-a-web-service-by-plsql-utl_http/
Best wishes!

[Matt Kohanek]

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!