How to configure stored procedures output parameters in execute stored procedures smart service to get data output from DB
Discussion posts and replies are publicly visible
Hi Nikhila, what is the type of procedure output?
two data outputs, one is int and one is varchar
Try to create two activity classs parameters with the same name as procedure output and then save the acp values in your pv.
i did same but its not working
In your Execute Stored Procedure smart service, you will configure procedure outputs as Node Inputs. E.g. if you have a value returned from the procedure as "result", you will create an Input as "result", then utilize the Save Into setting to store this to a PV. If this is not working, please share details on your current configuration if possible.
I had created inputs as you told, but its not working.
Can you share the screenshot of your node configuration?
These are the two outputs i need, configured them as inputs
To confirm, which parameter is the input to the stored procedure (as you noted 2 are outputs, there are 3 parameters total). The screen shots show both D_CASE_ID and D_CLCTN_AGNCY are setup to be procedure outputs, but I would expect error_msg to be one of the outputs and one of the above should be an input?
If one of those 2 is a procedure input, I would expect you to populate something for the value on the right, to get it into the procedure call.
I posted more detail from the documentation about this in this other similar recent thread. Overall my suggestion would be that if your SP is only for querying, and not for modifying data, you might consider handling the query SP call in an Expression Rule instead of in the node, as it's much more straightforward to grab (and then deal with) the output from the Rule version of execute stored procedure.