1. Community
  2. Studio
  3. Variables
  4. Ошибки
0
На рассмотрении

Connector MS SQL Server - sp output variable

zsery 6 лет назад в Studio / Variables • обновлен Elmo 6 лет назад • 3

Variable is declared (stored procedure) as output only. Studio needs declare as input too, why?
Response exists but MS SQL connector does not retrieve value in this variable (response  empty), why?

Generate mapping functionality generate only recordset mapping, it is correct< Is not missing mapping for output variable from stored procedure?

На рассмотрении
anonymous 6 лет назад

Hi zsery,

Thanks for you questions. Can you please provide us some details of your issues? Screenshots of the workflow and stored procedure would really help us resolve your query.

Thanks

zsery 6 лет назад

Hi,


If I use stored procedure (ms sql) with output parameter, it is ignored by wizard and the response value is ignored too. I try defined as input output but without success. Only response a recorset ( ms sql select) is accepted.

Elmo 6 лет назад

Hi zsery


Warewolf currently does not support the returning of out variables. If possible change the proc to return a table with one row and one column.

Thanks

Сервис поддержки клиентов работает на платформе UserEcho