How do I return the output parameter from a SQL stored procedure to an automation
I have a SQL stored procedure that creates a record in a table with an identity field and returns the value of the created identity. I placed a break point in the automation after the stored procedure is executed to check the value of the output parameter and the value is null. How do I return the output parameter from a SQL stored procedure to the automation?
Pegasystems Inc.
US
Change your return type to ReturnScalar for the SqlQuery component or change your stored procedure to use a Select instead of Return to pass your value back.
Verizon Sourcing LLC
I have multiple returned output variables from the stored procedure that return status and error messages. If the stored procedure is successful then it returns a record set. Is this supported?
EXECUTE sp_Test @User_id, @Machine_id, @Automation, @Step, @Other_Info, @Start_Datetime, @Finish_Datetime, @Return_Code OUT, @Return_Message OUT