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