aspose file tools*
The moose likes Web Services and the fly likes Can you pass complex type from pl sql to web service using utl_http Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "Can you pass complex type from pl sql to web service using utl_http" Watch "Can you pass complex type from pl sql to web service using utl_http" New topic
Author

Can you pass complex type from pl sql to web service using utl_http

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

Not sure if this belongs here or in JDBC forum really.

But I want to call a web service from pl sql and pass in a String (VARCHAR2) and a Type made up of 4 VARCHAR2 parameters
If I were just passing in a VARCHAR2 I would not have trouble. But I am unsure how to pass in a type, or even if I can do it in the first place.

I do not know exactly how to form the xml soap request. And I do not know what data type in the java to pass in the type to. The sql will be cast to a custom object, so can I just make the java parameter of that Object type?

That would simplify things, and I would just need to figure out how to form the xml for the soap request.
Or would it simply be easier to pass in 5 VARCHAR2 parameters?

Thanks


True wisdom is in knowing you know nothing - Socrates
Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
Hi!
If you are to call a SOAP web service, there should be a WSDL and, possibly, additional XML schemas. These will tell you how to assemble requests to the service.
Best wishes!


My free books and tutorials: http://www.slideshare.net/krizsan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can you pass complex type from pl sql to web service using utl_http