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]
@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.