Error While inserting data in stored procedure

Help Studio
, , , ,
1

Hi Everyone,

I am getting the below error while inserting data through Non Execute Query through procedure and I have also given parameters for insertion.

Do let me know what changes I need to do to resolve the issue.

Thanks in advance

IMG_20240208_110739
IMG_20240208_1107391920×831 115 KB

IMG_20240208_110715
IMG_20240208_1107151920×548 75.5 KB

2

Hello,

Please try to use Execute Query instead of Execute Non Query.

Please find below article:

Thanks

3

Hi @Binod_Kumar_Biswal

Try with in the parameters name use like @ID, @Subject.

And Check the database in which store procedure was created and the database used in connection.

4

Hi @ABHIMANYU_THITE1 ,

Thanks for the reply.

I have tried the suggested approach but still the same error is there

Kindly let me know if anything needs to he changed from my end.

IMG_20240208_123901
IMG_20240208_1239011920×947 136 KB

5

Hi @Pramod091257 ,

thanks for your response. Actually I need to insert data into a table through procedure so I was using Non Query activity, kindly suggest if you feel there is something other I need to act upon.

6

Hello Binod,

May I know which version of UiPath Studio and Database package you are using?

In the latest version of UiPath Studio 2022.4.5 and above we don’t have Execute non query activity.

Upgrade your DB package version to UiPath.Database.Activities.1.7.1 and try using “Run Command”

image

7

Also, could you please help me to provide the query you are trying to execute?