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.

asked 07 Dec '12, 16:06

ctang's gravatar image

ctang
16224
accept rate: 0%

edited 07 Dec '12, 16:12

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

(14 Dec '12, 07:29) Martin
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×125
×63
×19

question asked: 07 Dec '12, 16:06

question was seen: 5,223 times

last updated: 14 Dec '12, 07:29