ORA-01410: invalid ROWID while retrieving data from webapp.
I'm getting ORA-01410: invalid ROWID while retrieving data from a webapplication running on an oracle 10G database.
This application can dynamicaly build a webpage on which you can insert/update/delete on all oracle tables. And yes ROWID is used in the dynamicaly built where-clause in a query to retrieve/update rows. The error only fires on one particulary row in one table when trying to update it.
I look for a simpler solution then to just get rid of the ROWID in the where clause.
Do I need to rebuild the index on this particular table?
Is an analyze table x compute statistics enough? (dont think so)
Is there another sollution besides getting rid of the ROWID in the where clause of the query.
bit hard if you dont post the code - but the simplest and correct solution is to not use rowid
Click Here to Expand Forum to Full Width