Page 1 of 1

Evident memory corruption in TOraQuery

Posted: Mon 12 Mar 2007 07:11
by scarecrow
ODAC 5.80.0.37
Oracle 9.2.0.8/Linux
Delphi 7

The following trivial query crashes host application being executed by TOraQuery:

Code: Select all

select level from dual connect by level<=1000
There's probably a memory corruption or stack overflow. It's even more strange as this query is executed OK:

Code: Select all

select * from (
  select level from dual connect by level<=1000)

Posted: Mon 12 Mar 2007 10:47
by Challenger
We fixed bug with the Access Violation failure when executing this SQL statement when the Net option is True. But we couldn't fix the problem with fetching wrong amount of data. This seems to be a problem of Oracle Server. It returns the OCI_NO_DATA flag after fetching first block of data.