ArrayList obj = new ArrayList(); insert_pro insobj= new insert_pro(); OracleCommand cmd = new OracleCommand("ins1", conn); cmd.CommandType = CommandType.StoredProcedure; OracleParameter emp_obj = new OracleParameter(); for (int i = 0; i < arr_id.Count; i++) { insobj._Id = Convert.ToInt16(arr_id[i].ToString()); insobj._Name = arr_name[i].ToString(); insobj._Gender= arr_gender[i].ToString(); emp_obj.OracleDbType = OracleDbType.Object; emp_obj.Direction = ParameterDirection.Input; emp_obj.Size = arr_len; emp_obj.UdtTypeName = "SMP_EMP_TYPE"; emp_obj.Value = insobj; obj.Add(emp_obj); }
insert_pro insobj= new insert_pro();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)