When OracleLoader's LoadTable(IDataReader) gets executed, it throws an error "ORA-00957: duplicate column name".
The stack trace is:
Code: Select all
at Devart.Data.Oracle.OracleCommand.a(Int32 A_0, Boolean A_1, Int64[]& A_2)
at Devart.Data.Oracle.OracleCommand.ExecuteArray(Int32 iters)
at Devart.Data.Oracle.cg.n()
at Devart.Data.Oracle.OracleLoader.NextRow()
at Devart.Common.DbLoader.LoadTableInternal(IDataReader reader)
at Devart.Common.DbLoader.a(IDataReader A_0)
The source and destination tables are a replica of each other.
My code is:
Code: Select all
using (var loader = new OracleLoader("ABC.XYZ", conn, OracleLoaderOptions.NoLogging))
{
loader.CreateColumns();
string selectStatemnt = @"SELECT * FROM ABC.XYZCopy";
using (OracleCommand comm = new OracleCommand(selectStatemnt, conn))
{
using (var dataReader = comm.ExecuteReader())
{
loader.LoadTable(dataReader);
}
}
}