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));
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top