Procedure or function '<PROC Name>' expects parameter '@<value>', which was not supplied.. While exporting variables to MSQL store procedure

Help Studio
, , , , , ,
1

I have a store procedure in SQL in which I have an insert query in which I’m inserting several values as log of the transaction happened in UiPath flow, after configuring the “Executing Non Query” Activity I am getting the mentioned error " Procedure or function ‘’ expects parameter ‘@’, which was not supplied." Although I Have supplied the all the required arguments in the series.

Please Help.

2

@aryan.guru,

Welcome to the UiPath Community :slight_smile:

This will require to review your stored procedure as well. There is something in SP which is giving this error.

Please share your SP code here.

Thanks,
Ashok :slight_smile:

3

Check your parameter name copy it from SP and pass this as a parameter

image
image706×292 11.6 KB
and add it in UiPath Code its solve your issue, also make your parameter Null

As @ashokkarale asked you need to provide more details

4

Hi Ashok,

I worked fine, there was some missing configuration in the activity properties, rest all was fine.

Thanks

1 Like
5

@aryan.guru,

Glad I was helpful. Let’s close the topic by marking my answer as solution so it will be helpful to other members as well.

Thanks,
Ashok :slight_smile: