ORA-01036 with TSmartQuery (ODAC 7.00.0.2 and Delphi XE)

heidenbluth · Post by **heidenbluth** » 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?

AlexP · Post by **AlexP** » Wed 01 Dec 2010 11:38

Hello,

I could not reproduce the problem.
Please send a complete small sample to alexp*devart*com to demonstrate it including a script to create a table.