Question

Has anyone used "Database: Run stored procedure" ?

  • 29 August 2022
  • 3 replies
  • 15 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

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

Hi @Ikshit Dhawan​ ,

 

Its working.

 

Thanks & Regards

Sruthy

Your welcome @sruthy v b​ ,

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

 

Thank you,

Reply