Skip to main content
Question

Has anyone used "Database: Run stored procedure" ?

Cadet | Tier 2

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

    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

    Cadet | Tier 2
    • sruthy.v_0
    • Author
    • Cadet | Tier 2
    • September 1, 2022

    Hi @Ikshit Dhawan​ ,

     

    Its working.

     

    Thanks & Regards

    Sruthy

    • 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 & ConditionsAccessibility statement