winform调用oracle存储过程问题
zwliu 2013-08-22 11:57:41 oracle存储过程在sql developer下测试过,执行没问题.
winform 下代码如下:
int i_succeed;
using (OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings[station].ConnectionString))
{
con.Open();
OracleCommand cmd = con.CreateCommand();
cmd.CommandText = "sp_sellreserve";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("fromstation", OracleType.VarChar).Direction = ParameterDirection.Input;
cmd.Parameters.Add("tostation", OracleType.VarChar).Direction = ParameterDirection.Input;
cmd.Parameters.Add("fullpricecount", OracleType.Int32).Direction = ParameterDirection.Input;
cmd.Parameters.Add("ov_resultint", OracleType.Int32).Direction = ParameterDirection.Output;
cmd.Parameters["fromstation"].Value = "1000";
cmd.Parameters["tostation"].Value = "1737";
cmd.Parameters["fullpricecount"].Value = 2;
cmd.ExecuteNonQuery();
i_succeed = Convert.ToInt32(cmd.Parameters["ov_resultint"].Value.ToString());
con.Close();
}
但执行到cmd.ExecuteNonQuery();程序便无法执行,请大师们指点一下,问题在哪?