Calling wcf web service from stored procedure

[Former Member]

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?

Thanks.

[MCMartin]

The documentation is not very detailed, but have you tried 'SOAP:DOC'? For me it seems, as if SOAP:RPC is only supporting strings...