public void CreateMyLoader()
{
// Create and open connection
OracleConnection conn = new OracleConnection(
"User Id=Scott;Password=tiger;Data Source=Ora;");
conn.Open();
// Create loader instance
OracleLoader loader = new OracleLoader("loader_test", conn);
// Prepare for loading
loader.Open();
// Set row values
for (int i = 0; i < 10000; i++) {
loader.SetValue(0, i);
loader.SetValue(1, "test string");
loader.SetValue(2, DateTime.Now);
// Load next table row
loader.NextRow();
}
// Flush buffer and finish loading
loader.Close();
}