My Oracle Support Banner

Excel with VB for Applications (VBA) Fails With ORA-01445 cannot select ROWID (Doc ID 1293763.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle ODBC Driver - Version and later
Generic Windows
*** Checked for relevance on 26-Mar-2019 ***


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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.