-
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.
Regards,
BeeJay
-
bit hard if you dont post the code - but the simplest and correct solution is to not use rowid
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|