ORA-01843: Not a valid month + adonet + oledb provider

  • Thread starter Thread starter Wendell Rios
  • Start date Start date
W

Wendell Rios

Hi all,

I'm getting this message when updating a oracle date field in
production.
That works fine in development, there is, I couldn't reproduce this
behavior.

The user reported he could updated one record, but when tried to do it
for the next record this error message started to appear.

The SQL Update statement is using parameters. I'm providding here a
snippet of my code:

If you have any answer or suggestion, please feel free to contact me
at (e-mail address removed).

Thank you,

Wendell Rios.

//
// cmdUpdate
//
cmdUpdate.CommandText = @"UPDATE tblUser SET dtBalanceUpdate = ?,
idContainer = ?, nmUser = ?, vlBalance = ?, vlQuota = ? WHERE (idUser
= ?) ";
cmdUpdate.Connection = cn;
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("dtBalanceUpdate",
System.Data.OleDb.OleDbType.DBDate, 0, "dtBalanceUpdate"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("idContainer",
System.Data.OleDb.OleDbType.Integer, 0, "idContainer"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("nmUser",
System.Data.OleDb.OleDbType.VarWChar, 255, "nmUser"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("vlBalance",
System.Data.OleDb.OleDbType.Double, 0, "vlBalance"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("vlQuota",
System.Data.OleDb.OleDbType.Double, 0, "vlQuota"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_idUser",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "idUser", System.Data.DataRowVersion.Original,
null));
 
Back
Top