ADO uses ROWID on index-only table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ADO uses ROWID on index-only table

  1. #1
    Join Date
    Aug 2005
    Location
    Delft, the Netherlands
    Posts
    1

    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
    Posts
    138
    I am not a ADO guru,
    But you can try a update statement and execute it with the recordset.

    -dharma

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