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.

Regards,

BeeJay