ORA-01858: a non-numeric character was found where a numeric was expected

Help
1

Hi,

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

Date: 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.

2

The issue is here I hope
May I know what value does this column actually hold
And usually while sending variable to a sql statesmen in UiPath our @in front of the variable while defining like this @variablename

@hss

3

@Palaniyappan the type is TIMESTAMP(6) .It holds current date.
I didn’t understand… could u pls elaborate…

And usually while sending variable to a sql statesmen in UiPath our @in front of the variable while defining like this @variablename