C#中调用oracle的存储过程出现问题!

Question

OracleParameter p2 = new OracleParameter("name",OracleType.Varchar2,30);
p1.Value = "zhaoyinggang";
insert_CMD.Parameters.Add(p2);

Answer 1

改成这样的了,还是不行啊OracleCommand insert_CMD=new OracleCommand("INSERT_TEST",this.oracleConnection1);
   insert_CMD.CommandType=CommandType.StoredProcedure;
this.oracleConnection1.Open();   insert_CMD.Parameters.Add("pstudentID",OracleType.Number,15);
insert_CMD.Parameters["pstudentID"].Value=12345;
  insert_CMD.Parameters.Add("pname",OracleType.VarChar,30);
insert_CMD.Parameters["pname"].Value="nettedfish";
insert_CMD.ExecuteNonQuery();
this.oracleConnection1.Close();