How to execute stored procedure in uipath?

how to execute stored procedure in uipath?


Use Execute Query Activity,
Mention the Stored Procedure name


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.


hey @Rajasegar94 thank you so much for well explanation

While we try to execute stored procedure we need to make sure about the name of the DataBase as well, in case if we are passing DB name in Connection string then we can directly execute [dbo].[storedprocedurename] else [DBName].[dbo].[storedprocedurename] will save us from exception … :slight_smile: Enjoy…

Can you share a sample

Pardon me. What you mean by sample.

can you share a workflow to execute stored procedure in uipath


Which DB you want connect SQL server or Oracle or MySQL?

SQL server

It is fairly simple then. Can you give more detail on the exact issue you are facing?

Hi Rajasegar

I am connecting to Oracle DB. Can you please help on this


can I use execute non query activty? im trying to run stored proc that will do insert to sql server DB

Hello @ANjWolf,

Welcome to the UiPath Community!

Yes, you can use the Execute non Query activity, here’s a documentation and reference.

Happy Automation!