Q
Problem solve Get help with specific problems with your technologies, process and projects.

Solving the ORA-00904 error: invalid identifier in Oracle

Learn about ORA-00904, an invalid identifier error in Oracle, and how to solve it with this tip from Oracle expert Brian Peasland.

I have created a view and it is fetching the data properly. Then I used that view in four to five "Crystal Reports". In three reports it is opening properly, but in one report it is showing the ORA-00904 error. Can you help?

The ORA-00904 error is saying that you have specified an invalid identifier. This identifier could be the view name, or could be as simple as a syntax error. I would venture to say that the problem is not with the view. If the view works with multiple reports, then the view will work for all reports. It is the last report that is not calling the view correctly.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close