public int execute(string name)
{
this.getcon();
OracleCommand cmd=new OracleCommand();
cmd.Connection=con;
cmd.CommandText="test.test_pro";
cmd.CommandType=CommandType.StoredProcedure;
OracleParameter pra=new OracleParameter("b",OracleType.VarChar);
pra.Value=name;
pra.Direction=ParameterDirection.Input;
cmd.Parameters.Add(pra);
int i=new int();
pra=new OracleParameter("c",OracleType.Number);
pra.Direction=ParameterDirection.Output;
cmd.Parameters.Add(pra);
con.Open();
cmd.ExecuteNonQuery();
i=int.Parse((cmd.Parameters["c"].Value).ToString());
this.closecon();
return i;
}