Passing data to the Stored Procedure via Parameter using execute query

[pravin_calvin (pravin kumar)]

Hi @Paari_Ravi

Welcome to UiPath Community!

Please refer to the threads below.

How to execute stored procedure in uipath?

@rpadev Use Execute Query Activity, Mention the Stored Procedure name Regards, Mahesh

How execute a procedure in UiPath

I’m trying to execute a procedure with parameters but it is returning me this error [image]

Stored proc

Hello, We are trying to migrate all our codes from AA to UI Path. I’m having a hard time running a stored proc. Procedure name: usp_GetPreviousBusinessDate with parameters (‘ON’,‘$Date$’) Can you please advise me how to use activity Execute Query activity in this case or is this the right one? Thank you in advance

How to get value of Out Parameter of execute Query

Hello, So I find my way to this, and Yes if the parameter is set to Out, you can Declare your parameter in your StoredProcedure with the attribute “out” and it will be available in UIPath : eg CREATE PROCEDURE [dbo].[MY_STOREPROC] @myOutPut int out AS BEGIN SET @myOutPut = 2 END Then in UiPath you can call the storedProcedure with : parameter : myOutPut direction : out value : myVar

Regards