ORA-010007 : variable not in select list

[sandrine]

Delphi 7
Oracle client 7.3.4
Oracle server 7.3
ODAC 6.50.0.39

Delphi code
TOraQuery with default options
Sql is

Code: Select all

select code,title,value
from odac_long

At design time :

• add all fields in the field editor
  add a calculated field ( Tstringfield size 20 for example)

When you open the query, you get "Ora-01007 : variable not in select list"
It happens when you have both calculated fields and Tmemofields and only with Oracle 7.
The error occurs in Oraclasses in TOCIRecordSet.FetchPiece function

[Plash]

We have fixed this problem. The fix will be included in the next build of ODAC.