Skip to main content

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?

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. 

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.

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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings