Am trying to perform an update query, but i seem to be getting an error
RemoteException wrapping System.Data.OracleClient.OracleException: ORA-01858: a non-numeric character was found where a numeric was expected
sysdate = System.DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss")
My query looks like this:
"update tableName set col1 = 'A',col2= '"+var2+"' , update_date = 'TODATE(sysdate)', updated_by = '"+system.Environment.UserName+"' where col3 = '"+var3+"'"
I think it is an error with the way am passing the date… not sure… where am going wrong whether in query or date… pls help.