1. Community
  2. Studio
  3. Variables
  4. Błędy
0
W trakcie analizy

Connector MS SQL Server - sp output variable

zsery 6 lat temu w Studio / Variables • Ostatnio zmodyfikowane przez Elmo 6 lat temu • 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?

W trakcie analizy
anonymous 6 lat temu

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 lat temu

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 lat temu

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

Customer support service by UserEcho