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?
True wisdom is in knowing you know nothing - Socrates
Joined: Oct 04, 2006
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.