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