The customer has just noticed that one particular search they perform should return over 280,000 rows yet returns less than 10% of them.
The SELECT is performed with result sets mode turned on. Oracle doesn't support back end result sets so CTD should be implementing front end result sets (FERS).
The application does the SqlPrepareAndExecute() then calls SqlGetResultSetCount( )to get the number of rows selected.
- It returns around 20,800 instead of 283,464 (never consistently the same number, but always around 20,800)
- If let it loop, fetching the rows until no more data, 20,800 is how many it retrieves
- I don't see any FRS* files in the Windows temp. directory (should be there with FERS, right?)
- If I run the same SQL in Oracle's SQLPlus I get the full set of results.
I have tried turning on logging in SQL.INI. I get nothing unless I add the /FD switch (display fetch data) ... in which case I get everything, which grinds the whole thing to a halt.
Thanks in advance,
I doubt that this is even a CTD2000 specific issue, but for completeness:
Windows XP SP?
CTD 2.0 PTF-3
sqlwntm.dll: Version 7.5.1-PTF1 M Build 12531
sqlora32.dll: Version 2.0-PTF3 (PR3), Build 12756
ociw32.dll: Version 10.2.0.1.0
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production