Help with ora-1866?

Hi all,

(This is C#/ODP interface to Oracle DB)

I can't figure out what I'm doing wrong with this update query - any chance at a lil help? I saw a Metalink page that talked about "setting direct=n", but I don't have a clue as to what that means - lol!

(In the code below, I originally tried the date column with just the staight-up value of the column a DateTime, and got the same #$%$^# invalid date error.)

The code below invariably gives me "ORA-1866: the datetime class is invalid"

What am I doing wrong?

Thanks for any insights,

cdj

• code ============ string strConn = "user id=someone;password=password;data source=data"; OracleConnection dc_UAT = new OracleConnection(strConn); string updateString = @"update " + whichTable + " " + "set rate=:rate" + " " + "where indexid=:indexid and as_of_date=:AOD";

try
{

dc_UAT.Open();

OracleCommand oc = new OracleCommand(updateString, dc_UAT); oc.BindByName = true;

foreach (DataRow dr in data.Tables["tbl"].Rows)
{

OracleParameter paramIndexId = new OracleParameter();

paramIndexId.ParameterName = "indexid";
paramIndexId.Value = dr["indexid"];
paramIndexId.OracleDbType = OracleDbType.Int32;
paramIndexId.Direction = ParameterDirection.Output;

MessageBox.Show(paramIndexId.Value.ToString(), "value");

OracleParameter paramAsOfDate = new OracleParameter(); paramAsOfDate.ParameterName = "AOD";
paramAsOfDate.Value =
Convert.ToDateTime(dr["as_of_date"]).ToString("dd-MMM-yyyy"); paramAsOfDate.OracleDbType = OracleDbType.Date; paramAsOfDate.Direction = ParameterDirection.Output;

MessageBox.Show(paramAsOfDate.Value.ToString(), "date");

OracleParameter paramRate = new OracleParameter();

paramRate.ParameterName = "rate";
paramRate.Value = dr["rate"];
paramRate.OracleDbType = OracleDbType.Decimal;
paramRate.Direction = ParameterDirection.Output;

MessageBox.Show(paramRate.Value.ToString(),"rate");

oc.Parameters.Add(paramIndexId);
oc.Parameters.Add(paramAsOfDate);
oc.Parameters.Add(paramRate);

oc.ExecuteNonQuery();
}

//Final statusbar message

return true;
}
catch (Exception e)
{

this.ParentFormStatusBar.Text = basicText + "Save failed.";

return false;
}
finally
{

if (dc_UAT != null)
{

dc_UAT.Close();
}
} Received on Mon Feb 05 2007 - 18:20:01 CST