artmov
Scholar

Execute a SQL Stored Procedure action from Azure SQL group is not returning Output parameter

I have a Azure SQL connection.  On the database I have a basic stored procedure that takes one parameter and returns the Output parameter:

Alter PROCEDURE [BATCH].[FormType]
(
@Type varchar(10),
@Description nvarchar(250) OUTPUT
)

When I execute the SP locally on SQL, I can see the value of @Description.

Now, I am trying to create an Execute a SQL Stored Procedure action in NWC Workflow, but the Output value is coming back empty.  When I write a Select statement in the SP, I can see the results in the Output Object.  Is there a way to get the value of the Output parameter?

Labels: (1)
0 Kudos
Reply
3 Replies
Frankie
Nintex Professional Services Expert

Re: Execute a SQL Stored Procedure action from Azure SQL group is not returning Output parameter

According to the documentation, only one column of data can be retrieved. Furthermore, using 'AS JSON' could allow you to pack more into that one column. 

0 Kudos
Reply
DougReimers
Novice

Re: Execute a SQL Stored Procedure action from Azure SQL group is not returning Output parameter

Executes a command string or character string within a Transact-SQL batch, or one of the following modules: system stored procedure, user-defined stored procedure, CLR stored procedure, scalar-valued user-defined function, or extended stored procedure. The EXECUTE statement can be used to send pass-through commands to linked servers. Additionally, the context in which a string or command is executed can be explicitly set. Metadata for the result set can be defined by using the WITH RESULT SETS options.

0 Kudos
Reply
artmov
Scholar

Re: Execute a SQL Stored Procedure action from Azure SQL group is not returning Output parameter

It looks like the first sentence is cut off. I don't quite understand the suggestion.
0 Kudos
Reply