I am making a simple call to a wcf web service through a sql anywhere SP. Here is how my procedure looks like:
ALTER PROCEDURE "pass"."UploadVendor"( year integer, monthno integer, inout inoutheader long varchar, in inheader long varchar) url 'http://my.ubc.ca/Registration/UploadServices.svc/basic' TYPE 'SOAP:RPC' set 'SOAP(OPERATION=Upload)' soapheader '!inoutheader!inheader'
then i call the SP like this:
CALL "pass"."UploadVendor"("year" = 2012,"monthno" = 12,"inoutheader" = '< SOAPAction mustUnderstand="1" xmlns="http://schemas.microsoft.com/ws/2005/05/addressing/none" >http://tempuri.org/Ipass/Upload< /SOAPAction >',"inheader" = 'what I put here?')
(For display purpose, I put spaces around "SOAPAction" and "/SOAPAction" so that the tags will be displayed properly on this post. I don't have spaces when I actually make the call.)
I keep getting "Unsupported Media Type" error. I don't think I have set my "inoutheader" and "inheader" right. How should I set them?