Skip to main content
nikhilau0001
Known Participant
Feb 15, 2022 3:31 PM UTC
Question

Stored procedure

How to configure stored procedures output parameters in execute stored procedures smart service to get data output from DB

    12 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    Feb 15, 2022 3:59 PM UTC

    Hi Nikhila, what is the type of procedure output?

    nikhilau0001Author
    Known Participant
    Feb 15, 2022 4:03 PM UTC

    two data outputs, one is int and one is varchar

    gopalk2865
    gopalk2865
    Participating Frequently
    Feb 15, 2022 4:19 PM UTC

    Try to create two activity classs parameters with the same name as procedure output and then save the acp values in your pv.

    csteward
    csteward
    Brainy
    Feb 15, 2022 5:20 PM UTC

    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.

    nikhilau0001Author
    Known Participant
    Feb 16, 2022 5:22 AM UTC

    I had created inputs as you told, but its not working. 

    gopalk2865
    gopalk2865
    Participating Frequently
    Feb 16, 2022 5:24 AM UTC

    Can you share the screenshot of your node configuration?

    Terms & ConditionsAccessibility statement