Andrix
08-04-2005, 05:14 AM
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
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