Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ivan Krizsan
Ranch Hand
Posts: 2198
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic