OracleLoader not working with IDataReader

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
utoracle
Posts: 2
Joined: Wed 13 Feb 2019 08:36

OracleLoader not working with IDataReader

Post by utoracle » Wed 13 Feb 2019 08:54

I am evaluating the latest version of dotConnect for Oracle and I am running into an error while using OracleLoader.
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);
                        }
                    }
}

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: OracleLoader not working with IDataReader

Post by Pinturiccio » Fri 15 Feb 2019 13:54

We have released a new public build of dotConnect for Oracle on February 14, 2019. Please try using this newest build and notify us about the results. You can download the trial version of dotConnect for Oracle from our site https://www.devart.com/dotconnect/oracle/download.html

If the issue still can be reproduced with the version 9.6.696, then provide the following information:
1. Do you download and install the installation file or load dotConnect for Oracle via NuGet packages?
2. Oracle server version.
3. DDL script of both objects.
4. The connection mode you use: Direct or OCI.

Post Reply