当前位置: 代码迷 >> ASP.NET >> asp.net 和Oracle的过程简单有关问题,一直出错
  详细解决方案

asp.net 和Oracle的过程简单有关问题,一直出错

热度:8610   发布时间:2013-02-26 00:00:00.0
asp.net 和Oracle的过程简单问题,一直出错
protected void Button1_Click(object sender, EventArgs e)
  {
  string id = this.TextBox1.Text.Trim();
  string name = this.TextBox2.Text.Trim();
  string pwd = this.TextBox3.Text.Trim();
  string sex = this.TextBox4.Text.Trim();
  string strCn = "data source=zon;uid=system;pwd=pank;";
  OracleConnection cn = new OracleConnection (strCn);
  OracleCommand cmd = new OracleCommand("insaaa",cn);
  cmd.CommandType = CommandType.StoredProcedure;

  OracleParameter p1 = new OracleParameter("v_id", OracleType.Int32);
  p1.Direction = ParameterDirection.Input;
  p1.Value = id;

  OracleParameter p2 = new OracleParameter("v_name",OracleType.VarChar,10);
  p2.Direction = ParameterDirection.Input;
  p2.Value = name;

  OracleParameter p3 = new OracleParameter("v_pwd",OracleType.VarChar,20);
  p3.Direction = ParameterDirection.Input;
  p3.Value = pwd;

  OracleParameter p4 = new OracleParameter("v_sex",OracleType.VarChar,15);
  p4.Direction = ParameterDirection.Input;
  p4.Value = sex;

  cn.Open();
  int count = cmd.ExecuteNonQuery();
  cn.Close();
  if (count > 0)
  {
  ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('good!')</script>");
  }
  else
  {
  ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('false!')</script>");
  }
  }

代码如上,
过程如下
create or replace procedure Insaaa
(v_id number,
 v_name varchar2 ,
 v_pwd varchar2,
 v_sex varchar2
 )as
 begin
 insert into aaa values (v_id,v_name,v_pwd,v_sex);
 end;
过程没有错误,测试过了,但是程序调用就出错了,不知道为啥,高手指教,不胜感激;
ORA-06550: 第 1 行, 第 7 列: 
PLS-00306: 调用 'INSAAA' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored

------解决方案--------------------------------------------------------
楼主你的参数是定义了啊,但是你没有把它们添加到那个cmd中去也没有用啊
  相关解决方案