Skip to main content
S
Cadet | Tier 2
sruthy.v_0
Cadet | Tier 2
August 29, 2022
Question

Has anyone used "Database: Run stored procedure" ?

  • August 29, 2022
  • 3 replies
  • 554 views

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
    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
    sruthy.v_0Author
    Cadet | Tier 2
    September 1, 2022

    Hi @Ikshit Dhawan​ ,

     

    Its working.

     

    Thanks & Regards

    Sruthy

    I
    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