Skip to main content
N
nikhilau0001
February 15, 2022
Question

Stored procedure

  • February 15, 2022
  • 12 replies
  • 1 view

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
    February 15, 2022

    Hi Nikhila, what is the type of procedure output?

    N
    nikhilau0001Author
    February 15, 2022

    two data outputs, one is int and one is varchar

    gopalk2865
    gopalk2865
    Participating Frequently
    February 15, 2022

    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
    February 15, 2022

    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.

    N
    nikhilau0001Author
    February 16, 2022

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

    gopalk2865
    gopalk2865
    Participating Frequently
    February 16, 2022

    Can you share the screenshot of your node configuration?

    Terms & ConditionsAccessibility statement