• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Village Idiot
Posts: 484
jQuery Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 2198
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
reply
    Bookmark Topic Watch Topic
  • New Topic