Excel with VB for Applications (VBA) Fails With ORA-01445 cannot select ROWID
(Doc ID 1293763.1)
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version 188.8.131.52 and later
***Checked for relevance on 23-Jan-2013***
You are using Microsoft Excel to generate reports using data from Oracle. You are writing the code to generate these reports using Visual Basic for Applications (VBA) and the Oracle ODBC Driver. When you attempt to run your report you receive the following error:
-2147467259: [Oracle][ODBC][Ora]ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
The report fails to complete. Other reports may run fine. This may also occur when using Microsoft Access, VBA and the Oracle ODBC Driver.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!