query not returning enough rows

jdorlon · Post by **jdorlon** » Thu 09 Apr 2009 21:11

Hello,

I am using the latest ODAC with Delphi 2009. When I run this query, it returns 100 rows on Oracle 11, as it should. When I run the same query in Oracle 9, it only returns one row.

SQL Plus seems to work the same way, so it seems this is a bug in Oracle 9 - BUT - if I use an old build of our application which used ODAC 5.70 and Delphi 7, it returns the correct number of rows in Oracle 9.

I am using the same Oracle client - 9.2.0.1 in all cases.

SELECT ROWNUM
FROM dual
connect by level < 101

Thanks,

John

Plash · Post by **Plash** » Mon 13 Apr 2009 07:46

Set the PrefetchRows option of TOraQuery to 0. This will restore the old behaviour.

jdorlon · Post by **jdorlon** » Mon 13 Apr 2009 13:09

Thank you. I went to look up in the help exactly what PrefetchRows does, but in my Odac for RAD Studio 2009\Doc filter, there is no .chm file or anything else that I can open. I'm not sure if this is an installation bug or what. Here are the files that I have:

CRControls.HxA
CRControls.HxC
CRControls.hxs
CRControls.HxT
CRControlsF.HxK
CRControlsK.HxK
CRControlsN.HxK
Odac.HxA
Odac.HxC
Odac.hxs
Odac.HxT
OdacF.HxK
OdacK.HxK
OdacN.HxK

Plash · Post by **Plash** » Tue 14 Apr 2009 06:42

You can open the help by selecting Oracle | ODAC help or Help | CodeGear help in the RAD Studio menu. You can also download the *.chm file from our site.