一个简单的调用存储过程的问题（在线等）

[kurorolove]

存储过程：
create or replace procedure StatMonthOwe_tmp(publicnid in number) is
请问怎么用orahelper调用啊？我是这么写的：
OracleParameter[] Parms=new OracleParameter[1]{//传入共用nid
new OracleParameter(":publicnid", OracleType.Number)};
Parms[0].Value=Convert.ToInt32(dsmaxnid.Tables[0].Rows[0][0]);
OraHelper.ExecuteNonQuery(CommandType.StoredProcedure,"StatMonthOwe_tmp(:publicnid)",Parms);
但是老报错，请问这么写对吗？
另外存储过程我测试执行通过了

[kurorolove]

没我想要的答案啊

[Gangxintang]

OracleParameter[] Parms=new OracleParameter[1]{//传入共用nid
new OracleParameter(":publicnid", OracleType.Number)};
Parms[0].Value=Convert.ToInt32(dsmaxnid.Tables[0].Rows[0][0]);
OraHelper.ExecuteNonQuery(CommandType.StoredProcedure,"StatMonthOwe_tmp(:publicnid)",Parms);

[wuyq11]

string MyConnString = ConfigurationManager.ConnectionStrings["myDbConn"].ConnectionString;
OracleConnection Oraclecon = new OracleConnection(MyConnString);
OracleCommand myCMD = new OracleCommand();
myCMD.Connection = Oraclecon;
myCMD.CommandText = "";
myCMD.CommandType = CommandType.StoredProcedure;

OracleParameter para = new OracleParameter("A", OracleType.VarChar, 7);
para.Value = "";
para.Direction = ParameterDirection.Input;
myCMD.Parameters.Add(para);

para = new OracleParameter("B", OracleType.VarChar, 3);
para.Direction = ParameterDirection.Input;
myCMD.Parameters.Add(para);

para = new OracleParameter("C", OracleType.VarChar, 15);
para.Direction = ParameterDirection.Output;
myCMD.Parameters.Add(para);


Oraclecon.Open();
myCMD.ExecuteNonQuery();
for (int i = 0; i < myCMD.Parameters.Count; i++)
{
Response.Write(myCMD.Parameters[i].Value.ToString() + " <br>");
}
Oraclecon.Close();

[dlut_qimingxing]

OracleParameter[] Parms=new OracleParameter[1]{//传入共用nid
new OracleParameter("publicnid", OracleType.Number)};
Parms[0].Value=Convert.ToInt32(dsmaxnid.Tables[0].Rows[0][0]);
OraHelper.ExecuteNonQuery(CommandType.StoredProcedure,"StatMonthOwe_tmp",Parms);

其实就是把冒号去掉的问题。