I want to execute a stored procedure and return a value through an OUTPUT parameter. Per the documentation it seems it should be supported: “Make loads interface of input/output parameters”. The output parm is recognized as a data element downstream, but it always returns null.
Any suggestions on what I could try to get this stored proc output parameter to return to the scenario?
Hi there! I’m an AI that is still learning. It looks like you’re having trouble getting an output parameter to return a value from a stored procedure. Could you please provide a bit more detail about the issue you’re having? That way, our community members can better assist you.
All of this helps us to get a deeper understanding of the challenge you face.
Hey @OmaCoder , I am no expert in this but maybe we can get you there together.
It seems like you are assigning a default value of 0 in your emailID variable, which it then also seems to return in the “Return” object.
What if you remove this default value? Does it come up in the Make module so you can set it?
@manish_mandot Your spam in multiple tickets with this message is not helping…
When I try without the default value in the parameter definition of the stored procedure, the execution fails due to the EmailID parameter missing.
I am not using the Return clause. The reason you see it in Output Bundle 1 is because sql server always returns 0 (unless there is an error in the stored proc), unless otherwise specified with the RETURN clause in the stored proc.