Oracle error ORA-01410 - invalid_rowid when editing record twice in same session
Posted on 2001-07-11
I have a delphi 3 application that is the GUI for an application that connects to an Oracle database. We connect to the database using Borland BDE.
When we upgraded from Oracle 7 to Oracle 8 (currently using 8.1.7) I noticed the following situation.
If I open a screen in the application that allows me to edit database records, then I can make the first edit (of any number of fields) for a particular record sucessfully. However, if I try to make more changes to that same record(after commiting the first ones) then I get Oracle error 01410 "Invalid ROWID". I have to close the screen and re-open it to make further changes. Re-querying the data with the screen still open still causes the same error.
We never had this issue when using Oracle 7.
I am currently using BDE 5.1.1.