Hi All,

SA 12.0.1.4134.

In the database available via http there is a web service that calls my procedure. During the procedure, it may cause an error (tried raiserror and signal).

If the web service has TYPE set to 'XML', then the error text will be visible in this XML.

If the web service has TYPE set to 'JSON', then the error text is not visible, and the response body is generally empty.

Question: Is this error SA 12.0.1.4134 or does something need to be configured on the server ?

asked 06 Dec, 07:42

Stalker's gravatar image

Stalker
230111323
accept rate: 0%

edited 09 Dec, 14:43

Volker%20Barth's gravatar image

Volker Barth
32.6k328476696


Maybe that note from the v12.0.1.4484 readme is of help (or any other fix after build no. 4134 which is really old ...):

    ================(Build #4166  - Engineering Case #771444)================

    JSON services would have returned an empty document if an SQL error occurred. 
    This has been fixed so that an object containing one row with two keys, status: 
    “error”, and message: “<text of="" the="" sql="" error="" message="">”, is now returned.
permanent link

answered 06 Dec, 08:55

Volker%20Barth's gravatar image

Volker Barth
32.6k328476696
accept rate: 32%

edited 06 Dec, 08:56

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:

×427
×38
×7

question asked: 06 Dec, 07:42

question was seen: 45 times

last updated: 09 Dec, 14:43