static void Main(string[] args)
{
OracleClient Db = new OracleClient("SRTEST2", "ISCARDUSER", "Gbr18k6P");
//OracleClient Db = new OracleClient("sbdp-center-o07.bank.lan", "1521", "srtest2", "ISCARDUSER", "Gbr18k6P");
OracleConnection conn = Db.OpenConection();
Console.WriteLine("State: {0}", conn.State);
ArrayList param = new ArrayList();
param.Add(new AddParametrs("I_ID", 5244, OracleType.Int32, ParameterDirection.Input));
param.Add(new AddParametrs("I_REF_ROLE", 3724, OracleType.Int32, ParameterDirection.Input));
//OracleCommand cmd = new OracleCommand();
//cmd.Connection = conn;
//cmd.CommandText = strSql;
//cmd.CommandType = CommandType.Text;
//OracleParameterCollection prm = cmd.Parameters;
//Db.AddParameter("I_ID", 5244, OracleType.Int32, prm);
//Db.AddParameter("I_REF_ROLE", 3724, OracleType.Int32, prm);
//cmd.Prepare();
//OracleDataReader dr = cmd.ExecuteReader();
string strSql = "select t.* from SR_BANK.SR_USER t where t.ID =:I_ID and t.REF_ROLE =:I_REF_ROLE";
//string strSql = "select t.* from SR_BANK.SR_USER t";
OracleDataReader dr = Db.OracleExecuteQuery(strSql, param);
while (dr.Read())
{
Console.Write("{0}\t{1} \n", dr[0], dr[1]);
}
dr.Close();
Db.CloseConnection();
Console.WriteLine("State: {0}", conn.State);
}