【在线】向ORACLE中更新数据,当参数值为空字符串出错!
Conn=new OracleConnection("data source=ora28;user id=28;password=28");
Conn.Open();
OracleCommand cmdAddExam=new OracleCommand();
cmdAddExam.Connection=Conn;
cmdAddExam.CommandText="update FXGL_QUESTION set Q_REMARK=:Q_REMARK where Q_ID ="+ Convert.ToInt32(txtQ_id.Text);
cmdAddExam.Parameters.Add(":Q_REMARK",OracleType.VarChar);
cmdAddExam.Parameters[":Q_REMARK"].Value=OracleString.Empty;
// cmdAddExam.Parameters[":Q_REMARK"].Value=txtQ_Remark.Text.Trim() ;
'这里
'空字符串就报错:Parameter ':Q_REMARK': No size set for variable length data type: String.
cmdAddExam.ExecuteNonQuery();
cmdAddExam.Parameters.Clear();
Conn.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}