Skip to main content
Question

Has anyone used "Database: Run stored procedure" ?

  • August 29, 2022
  • 3 replies
  • 485 views
S
Cadet | Tier 2
Forum|alt.badge.img

I could save procedure output to .CSV file . But I couldn't assign the output to a variable (multiple variable / dictionary).Couldn't find much info from Docs page, syntax and examples would be better.

 

    3 replies

    I
    Forum|alt.badge.img+5
    • IkshitDhawan
    • Navigator | Tier 3
    • August 30, 2022

    No sure about the use case you are working on, but we can loop through the output of Stored Procedure using the same session name in the Loop -> Each Row in SQL dataset query

     

    Screenshot for your help:

     

    Run Stored Procedure Action:

    Run Stored Procedure 

    Complete Code:

     

    image 

    Works for me..

     

     

    Cheers,

    Ikshit Dhawan

    S
    Cadet | Tier 2
    Forum|alt.badge.img
    • sruthy.v_0
    • Author
    • Cadet | Tier 2
    • September 1, 2022

    Hi @Ikshit Dhawan​ ,

     

    Its working.

     

    Thanks & Regards

    Sruthy

    I
    Forum|alt.badge.img+5
    • IkshitDhawan
    • Navigator | Tier 3
    • September 1, 2022

    Your welcome @sruthy v b​ ,

    Could you please my comment as an answer to best help others in the community?

     

    Thank you,

    Terms & ConditionsCookie settingsAccessibility statement