用C#写的;数据库是oracle9i,表BOOK1只有一项ID,是number类型的;我想插入一列456
但是在发生ora-01036错误.
private void button1_Click(object sender, System.EventArgs e)
{
string ConnStr = "User ID=song;Password=song;Data Source=songora;Persist Security Info=True";
OracleConnection myConn = new OracleConnection (ConnStr); OracleCommand oraComm = new OracleCommand();
OracleTransaction myTrans;
oraComm.Connection = myConn;
oraComm.CommandType = CommandType.Text;//存储过程
oraComm.Parameters.Clear(); oraComm.Parameters.Add("pID",456);
oraComm.Parameters["pID"].Direction = ParameterDirection.Input; oraComm.CommandText = "insert into system.BOOK1(ID) values(pID)";
try
{
myConn.Open ();
myTrans = myConn.BeginTransaction();
oraComm.Transaction = myTrans;
oraComm.ExecuteNonQuery();
myTrans.Commit();
}
catch(OracleException orae)
{
MessageBox.Show(orae.ToString());
}
}
初学oracle,请问错在哪里?怎么改?多谢
但是在发生ora-01036错误.
private void button1_Click(object sender, System.EventArgs e)
{
string ConnStr = "User ID=song;Password=song;Data Source=songora;Persist Security Info=True";
OracleConnection myConn = new OracleConnection (ConnStr); OracleCommand oraComm = new OracleCommand();
OracleTransaction myTrans;
oraComm.Connection = myConn;
oraComm.CommandType = CommandType.Text;//存储过程
oraComm.Parameters.Clear(); oraComm.Parameters.Add("pID",456);
oraComm.Parameters["pID"].Direction = ParameterDirection.Input; oraComm.CommandText = "insert into system.BOOK1(ID) values(pID)";
try
{
myConn.Open ();
myTrans = myConn.BeginTransaction();
oraComm.Transaction = myTrans;
oraComm.ExecuteNonQuery();
myTrans.Commit();
}
catch(OracleException orae)
{
MessageBox.Show(orae.ToString());
}
}
初学oracle,请问错在哪里?怎么改?多谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货