DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008

    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.



  2. #2
    Join Date
    Sep 2002
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.