Page 1 of 1
TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Tue 07 Jan 2020 21:01
by heidenbluth
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.
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Sat 11 Jan 2020 14:14
by MaximG
Thank you for the information. We will investigate the described issue and let you know the results shortly.
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Wed 29 Jan 2020 12:00
by dados
I have the same issue with version 11.1.2 on Delphi 10.2.3
Downgraded to version 11.0.1 and that version does not throw this error
I'm using TOraQuery - Direct connect / NET
FetchAll := true;
ReadOnly := true;
NonBlocking := true;
Open; -> Error, but not everytime but more than 50%
This error only occurs for me when compiled as Release, newer in Debug
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Fri 31 Jan 2020 16:13
by MaximG
Please create and send us the source code of example that results in an error when you run it in your test environment. This will help us reproduce the behavior and find a solution. For your convenience, please use the e-support form
https://www.devart.com/company/contactform.html
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Fri 31 Jan 2020 17:23
by heidenbluth
Sample has been sent.
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Wed 05 Feb 2020 07:46
by sbslavonac
Same here, Delphi 10.3.2 ODAC 11.1.2., Oracle 12c
From what I know it happens on 12c, users on Oracle 11 are not complaining.
From error log:
Exception class: EOraError
Exception message: ORA-01002: fetch out of sequence
.
Exception address: 00D5EEB1
------------------------------------------------------------------------------
Main thread ID = 3576
Exception thread ID = 3576
------------------------------------------------------------------------------
Exception stack
Stack list, generated 05.02.2020 5:24:10
[00D5EEAC]{TouchPos.exe} OraClasses.TOCIConnection.OraError
[00D6B748]{TouchPos.exe} OraClasses.TOCICommand.Check
[00D70631]{TouchPos.exe} OraClasses.TOCICommand.InternalFetch
[00D7F19E]{TouchPos.exe} OraClasses.TOCIRecordSet.FetchArray
[00D7D2AE]{TouchPos.exe} OraClasses.TOCIRecordSet.InternalFetch
[00C9688E]{TouchPos.exe} CRAccess.TCRRecordSet.GetNextRecord
[00C1D168]{TouchPos.exe} MemDS.TMemDataSet.GetRecord
[0094650C]{TouchPos.exe} Data.DB.TDataSet.GetNextRecord
[009463E3]{TouchPos.exe} Data.DB.TDataSet.UpdateBufferCount
[00DB8638]{TouchPos.exe} Ora.TOraDataSet.OpenCursor
[00CC1421]{TouchPos.exe} DBAccess.TCustomDADataSet.SetActive
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Wed 12 Feb 2020 21:00
by heidenbluth
Any news regarding a fix?
It is more than 3 months ago now that I reported the bug including step by step instructions to reproduce.
Could you please provide an update that fixes the problem?
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Fri 21 Feb 2020 17:04
by MaximG
We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night ODAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form
https://www.devart.com/company/contactform.html
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Mon 19 Jul 2021 09:23
by MaximG
Kindly note that have released a new version of ODAC that contains the fix:
https://www.devart.com/odac/download.html
Re: TSmartQuery: ORA-01002 - fetch out of sequence error with ODAC 11.1.2
Posted: Mon 19 Jul 2021 09:30
by heidenbluth
Thank you