I'm a little confused... I'm trying to do a soap call a web service with a couple parameters... and I can't find any documentation that tells me what the right syntax is... and trial and error hasn't gotten me very far. The service is at http://someserver.com:3030/SecurityManagementService The method is called doAuthenticate The method has two parameters named in0 and in1. The method should return a string I started by creating this function, and it works great to show me the wsdl... :::SQL
An then I get stuck...where do I put the method name? I tried this, but it didn't work. And I don't know where to put the two parameters. :::SQL
I'm using 9.0.2. (I can easily upgrade for this project it that is helpful here.) thx! |
By default, the operation name is the same as the name of your SQL function. The parameters "in1" and "in2" should be parameters to the SQL function. You can also set the SOAP operation as described in CREATE FUNCTION statement (web clients) To quote that page:
Thanks Phil -- yet another reason to upgrade from 9.0.2. Looks like the OPERATION was added later.
(20 Apr '11, 11:48)
Ron Hiner
|
In 9.0.2 the procedure name is mapped the SOAP operation. If you do decide to upgrade, you can use wsdlc.exe to automatically generate SQL stored procedures (functions) to WSDL/DISH services. |