Passing data to the Stored Procedure via Parameter using execute query

[Paari_Ravi]

Hi ,

I want to pass the data to the Stored Procedure via Parameter from studio using execute query .But the declaration of the parameter in the Stored Procedure is in XML data type .

Sample :
Declare @Id XML = NULL
Declare @Name XML = NULL

Here how can i pass the parameter id from the studio .
In which data type i have to create a variable and pass it as a parameter in Studio.

Thanks in Advance ,
Paari

[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

[Paari_Ravi]

@pravin_calvin yes praveen ,i have done all the configuration properly . when i execute the query with out passing any parameter , the query executes successfully and fetches all the data from SP .

[arivu96 (Arivazhagan A)]

Hi @Paari_Ravi ,
use below format to pass values to storeprocedure
"EXEC procedureName @id='"+id.Tostring()+"',@Name='"+Name.ToString()+"'"

Regards,
Arivu

[Palaniyappan (Palaniyappan P)]

Hi

You have to give the parameter name in Name column
the direction of the parameter is a type of I/O
Type of the parameter in the Type column
passing a value to the parameter

You can search for the xml type browser for type and pass the parameters

Cheers @Paari_Ravi

[Paari_Ravi]

yeah i tried this way , in the execute query i have changed the CommandType as Stored Procedure , and passed the SP name in sql. and in the parameters i have to pass the data now.
Kindly refer the image

[arivu96 (Arivazhagan A)]

@arivu96

“EXEC procedureName @id='”+id.Tostring()+“‘,@Name=’”+Name.ToString()+“'”

Pass in the Sql commend, connection

Regards,
Arivu

[Paari_Ravi]

@Palaniyappan yes bro , i gave all the values , but im struck with passing the data in XML format .

[Paari_Ravi]

yes tried , but getting only the column names in the output , no data .

[arivu96 (Arivazhagan A)]

@Paari_Ravi what query you have given and any error ?
pls share the screenshot

Regards,
Arivu

[Paari_Ravi]

@arivu96 please find the attached image

[arivu96 (Arivazhagan A)]

Where did u passes parameters to store procedures

[Paari_Ravi]

If you see in the property panel there is an option Input and sub option Parameters where i pass the parameters.

[arivu96 (Arivazhagan A)]

you have passed correctly check from the database may be for that input no records available in the database.

Regards,
Arivu

[Paari_Ravi]

The data is available for that input in the DB. When i execute a query in SQL manager with parameters im getting the data.
IN Studio , when i tried to execute the query without any parameters im getting the whole data but i wonder why im not getting the data when i execute the data with parameters from studio .