Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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 '' 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="" >< /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?


asked 07 Dec '12, 16:06

ctang's gravatar image

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 07 Dec '12, 16:06

question was seen: 5,314 times

last updated: 14 Dec '12, 07:29