| 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
Bartender
Joined: Oct 04, 2006
Posts: 2194
|
|
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
|
 |
 |
|
|
subject: Can you pass complex type from pl sql to web service using utl_http
|
|
|