代码如下:
public static void jfzw_xz(string nbr, int paid_money, int pay_flag, string staff_id, out string O_writeoff_id, out string O_cursor_id, out string O_res, out string O_errinfo)
{
OracleParameter p1 = new OracleParameter( "i_acct_nbr ", OracleType.VarChar, 7);
p1.Value = nbr;
p1.Direction = ParameterDirection.Input;
OracleParameter p2 = new OracleParameter( "i_paid_money ", OracleType.VarChar, 8);
p2.Value = paid_money;
p2.Direction = ParameterDirection.Input;
OracleParameter p3 = new OracleParameter( "i_pay_flag ", OracleType.VarChar, 1);
p3.Value = pay_flag;
p3.Direction = ParameterDirection.Input;
OracleParameter p4 = new OracleParameter( "i_staff_id ", OracleType.VarChar, 3);
p4.Value = staff_id;
p4.Direction = ParameterDirection.Input;
OracleParameter p5 = new OracleParameter( "o_writeoff_id ", OracleType.VarChar, 10);
p5.Direction = ParameterDirection.Output;
OracleParameter p6 = new OracleParameter( "o_cursor ", OracleType.VarChar, 10);
p6.Direction = ParameterDirection.Output;
OracleParameter p7 = new OracleParameter( "o_res ", OracleType.VarChar, 3);
p7.Direction = ParameterDirection.Output;
OracleParameter p8 = new OracleParameter( "o_errinfo ", OracleType.VarChar, 100);
p8.Direction = ParameterDirection.Output;
OracleConnection conn = DB.jfzw();
conn.Open();
OracleCommand cmd = new OracleCommand( "jfzw.tams_bill.sp_cancel_account ", conn);
cmd.CommandType = CommandType.StoredProcedure;