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!