OracleLoader 8.4: COMMIT is not allowed in a subordinate session
Posted: Tue 27 Jan 2015 16:13
Devart.Data.Oracle version 8.1.36 class OracleLoader did work correcty.
But when upgrading to version 8.4.313 it started to throw exception:
But when upgrading to version 8.4.313 it started to throw exception:
This happens when calling .Open()-method inside DTC-transaction (using .NET Transaction-class).Devart.Data.Oracle.OracleException: ORA-02089: COMMIT is not allowed in a subordinate session
ORA-06512: at "SYS.DBMS_UTILITY", line 574
ORA-06512: at line 17
at Devart.Data.Oracle.a9.c(Int32 A_0)
at Devart.Data.Oracle.cu.a(Int32 A_0, cj A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Data.Oracle.v.a(Boolean A_0)
at Devart.Data.Oracle.v.b()
at Devart.Data.Oracle.ax.e()
at Devart.Data.Oracle.OracleLoader.Open()