oracle为参数赋值,Oracle 参数赋值

public void InsertLog(string logview, string table_name,string table_cname)

{

string sql = "";

byte[] buffer = System.Text.Encoding.Default.GetBytes(logview);

//sql = "UPDATE CAP_LOG SET LOG_TEXT =:LOG_TEXT WHERE TABLE_NAME=:TABLE_NAME";

sql = string.Format("INSERT INTO CAP_LOG (TABLE_NAME,IMP_DATE,LOG_TEXT,TABLE_CNAME) VALUES (:TABLE_NAME,to_date(:IMP_DATE,'yyyy-mm-dd hh24:mi:ss'),:LOG_TEXT,:TABLE_CNAME)");

OracleCommand cmd = new OracleCommand(sql, GetSqlConn);

cmd.Parameters.Add("TABLE_NAME",OracleType.VarChar);

cmd.Parameters.Add("IMP_DATE",OracleType.VarChar);

cmd.Parameters.Add("LOG_TEXT", OracleType.Blob);

cmd.Parameters.Add("TABLE_CNAME", OracleType.VarChar);

cmd.Parameters[0].Value = table_name;

cmd.Parameters[1].Value = DateTime.Now.ToString();

cmd.Parameters[2].Value = buffer;

cmd.Parameters[3].Value = table_cname;

try

{

cmd.ExecuteNonQuery();

}

catch(Exception ee)

{

MessageBox.Show("Error",ee.Message);

}

}