How to execute stored procedure in uipath?

activities
studio

#1

how to execute stored procedure in uipath?


#2

@rpadev

Use Execute Query Activity,
Mention the Stored Procedure name

Regards,
Mahesh


#3

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.


#4

hey @Rajasegar94 thank you so much for well explanation