Getting Error while using Stored Procedure in ExceuteNonQuery

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @nanmishra,

Execute Query (calling stored procedure) can needs some backend casting. As you noted UiPath takes in parameters as string while your stored procedure requires a cast to VarChar.

Try to use the string and cast it to varchar. A similar question where an int type is used:

SQL Stored procedure Passing Parameters To fetch particular records

Hi @pari_patel, I am assuming that you have set up your connection correctly using “Connect to DB” activity. The “Execute Query” activity takes the output of “Connect to DB” activity "Connect to DB" ---> "Execute Query" UiPath has a strict syntax requirement for parameters in the “Execute Query” activity (only takes String expressions). If your StoredProcedure takes in one parameter StoredProcedure = YourStoredProcedure Parameter for StoredProcedure = @YourRequiredParameter Variable f…

Hope this helps!