Execute Stored Procedures and Get the Output parameter using UiPath

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @dilii,

Take a look at this thread both suggested solutions will work.

SQL Stored procedure Passing Parameters To fetch particular records

How Should I fetch particular records from Stored Procedure? I am having difficulty to pass parameters. In my Stored Procedure there are 3 invoice account number having sales order list. I want to fetch separate records for each account number. Anyone can help me on this?

Your output will be off course be a datatable type.

Since you will have only one row output, you can then use

Assign activity

SQL output (string type) = YourResultDatatable.Rows(0).Item("YourColumnName").ToString