ORA-00904 Invalid Identifier.
Applies to: SQL Server 2005 Enterprise Edition, Oracle 9i
In SQL Server 2005 Enterprise Edition, we have set up an Oracle linked
server, but when we run a query with OPENQUERY, the following error shows up:
OLE DB provider "MSDAORA" for linked server "ODBCDataSource" returned message
"ORA-00904: : invalid identifier".
There could be many causes for this error message, but here you will find three of
1) The login used for creating the linked server to the Oracle database needs
permissions on one of the objects involved in the query.
2) The query may include a Oracle function that ODBC is not able to handle.
3) There is a column name either missing or invalid.