TOraQuery - select return 1 record

eml79 · Post by **eml79** » Thu 28 Jun 2007 11:24

I use ODAC version 6.10 on Oracle version 9.2.0.4
In TOraQuery I try execute this command:
select * from DUAL CONNECT BY LEVEL <= 5

and i get 1 record.
If I set TOraQuery.Options.AutoPrepare = TRUE then I get 5 record, but component send 2 query to server (I do not need is).

In ODAC version 5.55 this command return 5 record independent of value of TOraQuery.Options.AutoPrepare.

Is it a BUG?

Challenger · Post by **Challenger** » Mon 02 Jul 2007 08:25

This problem is caused by Oracle Prefetching mechanism that is enabled in ODAC 6 (and was disabled in previous versions of ODAC). In the next build we will add option to TOraDataSet that allows to enable/disable Prefetching.