Devart Forums

Code: Select all

var employees = new List<Employee>();
employees.add (new Employee {id=1, name="joe", HireDate=xxx});
employees.add (new Employee {id=2, name="mike", HireDate=xxx});
employees.add (new Employee {id=3, name="scott", HireDate=xxx});

Code: Select all

OracleParameter op = new OracleParameter("InputParamNameInProc", OracleDbType.Table);
op.Direction = System.Data.ParameterDirection.Input;
OracleTable table = new OracleTable(OracleType.GetObjectType("tableTypeName", _connection));

table.Add(employees);
op.Value = table;
cmd.Parameters.Add(op);
cmd.ExecuteNonQuery();

Code: Select all

CREATE TYPE Employee AS OBJECT (
  id NUMBER,
  name VARCHAR2(30),
  HireDate Date
);

CREATE TABLE EMPLOYEE_TABLE (
  ID  NUMBER(10, 0),
  VAL EMPLOYEE
)

Code: Select all

OracleConnection conn = new OracleConnection("host=orcl1120;uid=semenb;pwd=tiger;");
conn.Open();

OracleType employeeType = OracleType.GetObjectType("EMPLOYEE", conn);
List<OracleObject> employees = new List<OracleObject>();
            
OracleObject employee = new OracleObject(employeeType);
employee["id"] = 1;
employee["name"] = "joe";
employee["HireDate"] = DateTime.Today;
employees.Add(employee);

employee = new OracleObject(employeeType);
employee["id"] = 2;
employee["name"] = "mike";
employee["HireDate"] = DateTime.Today;
employees.Add(employee);

employee = new OracleObject(employeeType);
employee["id"] = 3;
employee["name"] = "scott";
employee["HireDate"] = DateTime.Today;
employees.Add(employee);

OracleLoader loader = new OracleLoader();
loader.Connection = conn;
loader.TableName = "EMPLOYEE_TABLE";
loader.CreateColumns();
loader.Open();

for (int i = 0; i < employees.Count; i++)
{
    loader.SetValue("id", i);
    loader.SetValue("val", employees[i]);
    loader.NextRow();
}
loader.Close();

Code: Select all

                    OracleLoader loader = new OracleLoader();
                    loader.Connection = _connection;
                    loader.TableName = "Employees";
                    loader.CreateColumns();
                    loader.Open();

                    for (int i = 0; i < employees.Count; i++)
                    {
                        loader.SetValue("Id", employees[i].Id);
                        loader.SetValue("Name", employees[i].Name);
                        loader.SetValue("HireDate", employees[i].HireDate);

                        loader.NextRow();
                    }

                    loader.Close();