ORA-010007 : variable not in select list
Posted: Fri 26 Sep 2008 10:12
Delphi 7
Oracle client 7.3.4
Oracle server 7.3
ODAC 6.50.0.39
Delphi code
TOraQuery with default options
Sql is
At design time :
It happens when you have both calculated fields and Tmemofields and only with Oracle 7.
The error occurs in Oraclasses in TOCIRecordSet.FetchPiece function
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
- add all fields in the field editor
add a calculated field ( Tstringfield size 20 for example)
It happens when you have both calculated fields and Tmemofields and only with Oracle 7.
The error occurs in Oraclasses in TOCIRecordSet.FetchPiece function