Procedure在C#程序中单独的调用方法
1.只有输入参数的存储过程
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "PROC_User_INSERT";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.BindByName = true;
cmd.Parameters.Add(new OracleParameter("TIME_STAMP", OracleDbType.Varchar2, strTimeStamp, ParameterDirection.Input));
cmd.Parameters.Add(new OracleParameter("User_ID", OracleDbType.Varchar2, strProgramId, ParameterDirection.Input));
cmd.Parameters.Add(new OracleParameter("User_NM", OracleDbType.Varchar2, strUserId, ParameterDirection.Input));
cmd.ExecuteNonQuery();
2,有输出的存储过程
var cmd = new OracleCommand();
cmd.CommandText = ProcedureName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = DBcon.DbConn;
cmd.BindByName = true;
cmd.Parameters.Add(new OracleParameter("aaa", OracleDbType.Int32, 0, ParameterDirection.Output));
cmd.Parameters.Add(new OracleParameter("bbb", OracleDbType.NVarchar2,string.Empty, ParameterDirection.Output));
cmd.Parameters["aaa"].Size = 4;
cmd.Parameters["bbb"].Size = 256;
cmd.ExecuteNonQuery();
var sts = cmd.Parameters["aaa"].Value.ToInt(999);
var msg = cmd.Parameters["bbb"].Value.ToString();
3.既有输入参数又有输出参数的综合上边两个,写法一样