Home » SQL & PL/SQL » SQL & PL/SQL » Call a .net web service from pl/sql where the input parameter is a .net object
Call a .net web service from pl/sql where the input parameter is a .net object [message #227813] Thu, 29 March 2007 08:24 Go to next message
chillindan
Messages: 17
Registered: November 2006
Location: UK
Junior Member
I am implementing .net web services using the utl_http package. It is all working fine when I need to call a web method that accepts simple types as the parameters such as xsd:string or xsd:int, but there are several methods I need to call that accept simple types and complex types as the input parameters.

Has anyone got any idea of the syntax I need to use to add this type of parameter to my soap request? I know when you are calling .net web services from .net you just add a web reference to the code and can then create an object of the complex type, populate it with data and then add it to your request.

Dealing with a complex type in the response is fine as I just take the response and put it in an xmltype attribute and can then parse it from there.

Any ideas, someone must have tried to do this before, surely?
Re: Call a .net web service from pl/sql where the input parameter is a .net object [message #228698 is a reply to message #227813] Tue, 03 April 2007 14:42 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://awads.net/wp/2005/11/30/http-post-from-inside-oracle/

http://technology.amis.nl/blog/?p=358
Previous Topic: Insert using DBLINK; Trigger not getting executed.
Next Topic: automatic primarykey
Goto Forum:
  


Current Time: Thu Dec 08 00:10:53 CST 2016

Total time taken to generate the page: 0.06356 seconds