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?