Hi, I am creating a Webservice in SQL-Anywhere 10 and I want to let this service be called with POST method, and pass the parameters within the body of the HTTP request.

I get an error message when I use the HTTP_BODY function Procedure 'HTTP_BODY' not found, whereas the function HTTP_HEADER does work in the same version of DB.

Is this a version problem, or missusing of the function?

CREATE PROCEDURE "Mytest" ()

RESULT (UpdResult VARCHAR)

begin

declare exbody varchar(500);

set exbody = HTTP_BODY('');

insert into mytesttable values (exbody);

select 'finished successfully';

end;

asked 06 Dec '19, 07:25

Sako's gravatar image

Sako
1.0k395288
accept rate: 25%

edited 06 Dec '19, 07:28


According to the published docs, that function was introduced with SQL Anywhere 11.0.

permanent link

answered 06 Dec '19, 08:00

Volker%20Barth's gravatar image

Volker Barth
36.0k342501748
accept rate: 34%

Isnt there another alternative / workaround to extract the body of a HTTP Request in Version 10?

(06 Dec '19, 08:13) Sako
Your answer
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:

×52
×23

question asked: 06 Dec '19, 07:25

question was seen: 153 times

last updated: 06 Dec '19, 08:13