Paginal access with OracleDataTable

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply

Paginal access with OracleDataTable

Post by Simon » Tue 30 Nov 2004 08:51


I am testing the paginal access of the OracleDataTable Class, but the following error occurs:

Setting the StartRecord-Property to 0 the first access is successfull, but if I increase the value and call the update method an exception (see below) is thrown.

This exception is not thrown if the StartRecord-Property for the first access is set higher than 0.

Am I doing something wrong?

Best regards

CoreLab.Oracle.OracleException: OCI invalid handle.
at a.c.q.a(Int32 A_0)
at CoreLab.Oracle.OracleConnection.a(Int32 A_0)
at CoreLab.Oracle.OracleCommand.a(Int32 A_0)
at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, Disposable A_1)
at CoreLab.Common.DbCommandBase.b(CommandBehavior A_0)
at CoreLab.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at CoreLab.Oracle.OracleCommand.ExecuteReader(CommandBehavior behavior)
at CoreLab.Oracle.OracleCommand.a(String A_0, Int32 A_1)
at CoreLab.Oracle.OracleCommand.a(Boolean A_0, Int32 A_1, Int32 A_2)
at CoreLab.Common.DbCommandBase.a(CommandBehavior A_0, Int32 A_1, Int32 A_2)
at CoreLab.Oracle.OracleCommand.ExecutePageReader(CommandBehavior behavior, Int32 startRow, Int32 pageSize)
at CoreLab.Oracle.OracleDataTable.a(IDbCommand A_0, Int32 A_1, Int32 A_2)
at CoreLab.Common.DbTable.FillPage(Int32 startRecord, Int32 maxRecords, Object[] parameterValues)
at CoreLab.Common.DbTable.FillPage(Int32 startRecord, Int32 maxRecords)
at CoreLab.Common.DbTable.set_Active(Boolean value)

Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Paginal access with OracleDataTable

Post by Oleg » Fri 03 Dec 2004 10:29

This problem has already been fixed in the new beta of OraDirect .NET 2.50 (29.11.04).
Please download it and test the problem again.

Post Reply