Another problem with StatementCache

[Tailor K]

I had problems with large number of cursors opened on the server side, so I set the StatementCache to True. One new problem arise: on a dataset, I update any field to null and post it (using a standard dbgrid) - if I do this again on another row, a second time, in sequence, I get a ORA-01410 invalid RowID. Using OracleMonitor, the RowID IS valid...
For now, I am disabling StatementCache - this occurs on Delphi 6 UP 2/3 with DOA 4.0.7.1.
I made a standalone project using the Scott tables, easy to reproduce.

 

[Marco Kalter]

We'll check it out. What is your oracle client and server version?

 

[Tailor K]

I made this happens on clients 10.1.0.2, 10.1.0.4 and 9.2.0.4 and 9.2.0.6, against database 10.1.0.4 on Linux and Windows.

 

[Tailor K]

Hi, any news on that question?

Tailor K.