asp.net调用oracle存储过程
OracleParameter[] parms = {
new OracleParameter("U_ID",OracleType.Number,10)
};
parms[0].Value =U_ID;
int a = DbHelper.ExecuteNonQuery("vip_recharge", CommandType.StoredProcedure, parms);
return a > 0 ? true : false;
其中U_ID为70测试数据
报出PLS-00306: wrong number or types of arguments in call to 'VIP_RECHARGE'
public int ExecuteNonQuery(string commandText, CommandType commandType, OracleParameter[] parameters)
{
int count = 0;
using (OracleConnection connection = new OracleConnection(connectionString))
{
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.CommandType = commandType;//设置command的CommandType为指定的CommandType
//如果同时传入了参数,则添加这些参数
if (parameters != null)
{
foreach (OracleParameter parameter in parameters)
{
command.Parameters.Add(parameter);
}
}
connection.Open();//打开数据库连接
count = command.ExecuteNonQuery();
}
}
return count;//返回执行增删改操作之后,数据库中受影响的行数
}