OracleConnection con=new OracleConnection(strcon);
OracleCommand cmd=new OracleCommand();
OracleTransaction mytrans ;
try
{
con.Open ();
mytrans =con.BeginTransaction();
cmd.Connection =con;
cmd.CommandText =rfgetid;
cmd.CommandType =CommandType .StoredProcedure;
cmd.Transaction =mytrans ;

OracleParameter parameter_in=new OracleParameter(as_bm,OracleType.Char);
OracleParameter parameter_out=new OracleParameter (as_sxh,OracleType .Number );

parameter_in.Direction =ParameterDirection .Input;
parameter_out.Direction=ParameterDirection .Output ;

parameter_in .Value =tblname.ToUpper();

cmd.Parameters .Add(parameter_in );
cmd.Parameters.Add(parameter_out);

cmd.ExecuteNonQuery();
mytrans .Commit();
return int.Parse(parameter_out .Value.ToString()) ;

}
catch(Exception er)
{
throw new Exception(er.Message);
mytrans .Rollback();

}
finally
{
cmd.Dispose ();
con.Close ();

}