I’m trying to insert integer value into oracle database but getting following error :
RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00936: missing expression
I have performed below steps :
- read the data from excel and stored it in data table.
- opened the connection string
- converted variable to int 32 datatype and passing that argument into insert query. e.g. “insert into table_name (column_name) values (@argument_name)”
Note : datatype of column_name in oracle database is NUMBER and datatype of argument is int 32.