DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Delft, the Netherlands

    Angry ADO uses ROWID on index-only table

    Hi all,

    When using ADO (2.7) on an Oracle table created as "ORGANIZATION INDEXED", I get ORA-01410 (invalid ROWID) errors as soon as I update a record in a recordset (rstData.Update). AddNew works fine. I know index-only tables do not have an ROWID, so if ADO (provider OraOLEdb) uses them on this kind of table, the error makes sense. For performance/storage we desperately need this type of table (Prim.key is 75% of the record, w're talking millions of records), so does anyone know of a workaround?

    André Hendriks

  2. #2
    Join Date
    Dec 2000
    I am not a ADO guru,
    But you can try a update statement and execute it with the recordset.


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.