How to query two database

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @MasterOfLogic ,

if you want to execute stored procedure you have to use execute non query activity and select the command type as stored procedure and give your stored procedure name in the Sql field. please refer the below thread for more guidance. thanks.

How to execute stored procedure in uipath?

Use Execute query activity under Database. If it is not available install the UiPath.Database.Acitivities package.Use configure connection and connect to DB. In properties Fill the SP name against SQL. In Parameter pass input values with direction IN. Choose command type as Store procedure You can Store the return output in a DT variable if needed. [image]