Oracle 19.3.0.0 and Direct mode

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ogi
Posts: 12
Joined: Wed 19 Oct 2016 07:19

Oracle 19.3.0.0 and Direct mode

Post by ogi » Fri 09 Aug 2019 12:14

Question.

Does the latest dotConnect for Oracle support Oracle 19.3.0.0 and to what extent?

I'm getting strange errors when using it to insert large amounts of data (via a 3rd party library, Z.EntityFramework.Extensions, but nonetheless) and I'm only getting them when running Devart in Direct mode...

Code: Select all

Stack trace:
System.Exception: An error occurred while updating the entries. See the inner exception for details. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Devart.Data.Oracle.OracleException: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [10] [10] [] [] [] [] [] ---> Devart.Data.Oracle.OracleException: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-4] [10] [10] [] [] [] [] []
  at at Devart.Data.Oracle.ed.a(dk A_0, Int32 A_1)
  at at Devart.Data.Oracle.ed.a(Int32 A_0, ei A_1)
  at at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
  at at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
  at at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
  at at Devart.Data.Oracle.OracleCommand.a(Int32 A_0, Boolean A_1, Int64[]& A_2)
  --- End of inner exception stack trace ---
  at at Devart.Data.Oracle.OracleCommand.a(Int32 A_0, Boolean A_1, Int64[]& A_2)
  at at Devart.Data.Oracle.OracleCommand.ExecuteArray(Int32 iters)
  --- End of inner exception stack trace ---
  at at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
  at at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
  at at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
  at at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
  at at .(DbCommand , BulkOperation , Int32 )
  at at .( , DbCommand )
  at at .Execute(List`1 actions)
  at at .(List`1 )
  at at Z.BulkOperations.BulkOperation.Execute()
  at at Z.BulkOperations.BulkOperation.BulkUpdate()
  at at .(List`1 , Object , Dictionary`2 )
  at at .Execute()
  --- End of inner exception stack trace ---
  at at .Execute()
  at at DbContextExtensions.(DbContext this, Boolean , Action`1 , Boolean )
  at at DbContextExtensions.BulkSaveChanges(DbContext this, Boolean useEntityFrameworkPropagation, Action`1 bulkOperationFactory)
  at at DbContextExtensions.BulkSaveChanges(DbContext this)
The exception occurs when executing the following statement:

Code: Select all

Statement: 
- UPDATE T_MEASUREMENT SET "STATUS" = :P_0 WHERE "ID" = :P_1

Parameter info:
- P_0, Input param, Type=Number, Value = System.Object[]
- P_1, Input param, Type=Number, Value = System.Object[]
Library details:
EF version: 6.1.3
Database Provider: Devart dotConnect for Oracle 9.7.770.0 (using Direct mode)
Oracle database 19.3.0.0

I'm posting this on your forum because the library works when I disable direct mode - running via Oracle client works as expected.

Shalex
Site Admin
Posts: 9103
Joined: Thu 14 Aug 2008 12:44

Re: Oracle 19.3.0.0 and Direct mode

Post by Shalex » Thu 15 Aug 2019 19:05

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

ogi
Posts: 12
Joined: Wed 19 Oct 2016 07:19

Re: Oracle 19.3.0.0 and Direct mode

Post by ogi » Sun 18 Aug 2019 12:18

Thank you.

Shalex
Site Admin
Posts: 9103
Joined: Thu 14 Aug 2008 12:44

Re: Oracle 19.3.0.0 and Direct mode

Post by Shalex » Sat 14 Sep 2019 11:03

The bug with using array binding on Oracle 19c in the Direct mode is fixed: viewtopic.php?f=1&t=39337.

Post Reply