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;
==> It produces ORA-01002 fetch out of sequence error!
Please help.