Getting Error while using Stored Procedure in ExceuteNonQuery

[nanmishra]

Hi, I am trying to access a Stored Procedure to update a data table. I have passed the stored procedure name and the table name as input parameters. However when we execute I get the following error : Run command: The type of column ‘Assets Held Currency Code’ is not supported. The type is ‘Object’. The Column ‘Assets Held Currency Code’ is the first column in the table and it is defined as string in UIPath and VarChar in Stored Procedure.

Please help.

[Lak_Ui (Lakshmi)]

seems like there is a type mismatch in the column names defined in the stored procedure and in uipath studio

[nanmishra]

Thanks @Lak_Ui for your help.

I am basically getting the data from an excel into datatable and am passing this table directly as parameter to the ExecuteNonQuery. As it is a datatable created from READ Range activity(without preserve format), so all the columns will automatically be String in UIPATH.

What I am not sure is that in this case does the datatable defined in the StoredProcedure also need to have all the columns as String(VarChar).

[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!

[nanmishra]

Thanks @jeevith for your help.

As am new to the database part, just wanted to clarify:

1. My datatable that I pass from UIPATH as parameters(in_dttabledata) will have all columns as string. The parameter(@CurrencyExposure) in the Stored Procedure should also be defined as a datatable with columns of type varchar first. Then in SQL the coding should be to loop at this parameter table and pass to separate variables which would be of datatype similar to the TABLE that will be updated with the record)

[nanmishra]

Solved. Just for information so that it can help others : when using Read Range to read all data from excel the data table columns were of type Object. Had to loop at the table and convert all data type to String to solve the issue.