ORA-01858 error on Windows deployment server
Posted: Mon 22 Feb 2010 17:27
Hi there,
I'm passing in a date time like so:
This works fine locally but when I put the service on my windows server (2003) I receive the error:
ORA-01858 a non-numeric character was found where a numeric was expected
Any ideas as to what I may be missing on my deployment server?
Thanks.
I'm passing in a date time like so:
Code: Select all
OracleParameter inDateTime = new OracleParameter();
inDateTime.Value = "01-01-2010";
inDateTime.ParameterName = "IN_DOI";
inDateTime.DbType = DbType.Date;
myCommand.Parameters.Add(inDateTime);
inDateTime.Direction = ParameterDirection.Input;
ORA-01858 a non-numeric character was found where a numeric was expected
Any ideas as to what I may be missing on my deployment server?
Thanks.