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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading