ORA-01036 with TSmartQuery (ODAC 7.00.0.2 and Delphi XE)
Posted: Wed 01 Dec 2010 08:45
I upgraded my application from Delphi 2009/ODAC 6.90 to Delphi XE/ODAC 7.0 . When updating grid values using a TSmartQuery component it behaves like that:
- The updated row vanishes from the grid after post
- I get ORA-01036: Invalid variable name/number
from the BindParam method when posting again.
DB version is 9.2, OCI 10.2.
Oracle 10.2 is very similiar:
- The updated row does not vanish, but gets empty. All grid cells go blank.
- The first update works, starting with the second update I get ORA-01036
Direct TCP/IP option does not help either.
Do you have any ideas what goes wrong here?
- The updated row vanishes from the grid after post
- I get ORA-01036: Invalid variable name/number
from the BindParam method when posting again.
DB version is 9.2, OCI 10.2.
Oracle 10.2 is very similiar:
- The updated row does not vanish, but gets empty. All grid cells go blank.
- The first update works, starting with the second update I get ORA-01036
Direct TCP/IP option does not help either.
Do you have any ideas what goes wrong here?