ORA-01858 error on Windows deployment server

[dbelanger]

Hi there,

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;

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.

[Shalex]

It seems like the regional settings in your development and deployment environments are different. As a result, the string representation of the date is parsed using different date formats. You can apply one of the following workarounds:
1) avoid setting a date via a string and use

Code: Select all

inDateTime.Value = new DateTime(2010, 01, 01);

instead of

Code: Select all

inDateTime.Value = "01-01-2010";

2) reset the Devart.Data.Oracle.OracleGlobalization.DateFormat value in your deployment environment to override the system (default) format for your application locally.

[dbelanger]

Thanks, worked great.