使用OracleBulkCopy 方法批量插入数据到orcale数据库时出现错误,错误提示如下
orcale引用的dll如下
方法体如下
public static void ExcuteBulkData(DataTable table, string targetTableName)
{
bool result = false;
using (OracleConnection conn = new OracleConnection(GetConnectionString()))
{
using (OracleBulkCopy bulkCopy = new OracleBulkCopy(GetConnectionString(), OracleBulkCopyOptions.UseInternalTransaction))
{
if (table != null && table.Rows.Count > 0)
{
bulkCopy.DestinationTableName = targetTableName;
for (int i = 0; i < table.Columns.Count; i++)
{
string col = table.Columns.ColumnName;
bulkCopy.ColumnMappings.Add(col, col);
}
conn.Open();
bulkCopy.WriteToServer(table);
result = true;
}
}
}
//return result;
}
|