TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
heidenbluth
Posts: 50
Joined: Mon 08 Nov 2004 19:01
Location: Germany

TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by heidenbluth » Tue 07 Jan 2020 21:01

Hello,

There is a serious problem with ODAC 11.1.2 that did not exist with ODAC 10.3.9.
You can reproduce it easily by following these steps:
* Use Delphi XE 10.3.3 and Oracle 19c (SQL*Net connection)
* Create a new application
* Add a TOraSession, TLoginDialog, TSmartQuery, TOraDatasource and TDBGrid component and connect components with each other.
* Connect to HR schema
* Set SQL to SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES

Add a TButton and implement the Button.OnClick event as follows:

Code: Select all

  OraSession1.Connect;
  SmartQuery1.NonBlocking := True;
  SmartQuery1.ObjectView := True;
  SmartQuery1.FetchRows := 2000;
  SmartQuery1.Prepare;
  SmartQuery1.Active := True;
Run the application, and click the button
==> It produces ORA-01002 fetch out of sequence error!

Please help.

MaximG
Devart Team
Posts: 1469
Joined: Mon 06 Jul 2015 11:34

Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2

Post by MaximG » Sat 11 Jan 2020 14:14

Thank you for the information. We will investigate the described issue and let you know the results shortly.

Post Reply