I’m using Toad for Data Analysis (TDA) 2.0.0.841 with an Oracle 9i DB and I’ve searched around a bit and couldn’t find the answer to my problem. My initial suspicion is that this is a privilege issue, but I’m not sure…
If I pop open an Editor in TDA and write a simple query like
SELECT PROJECT.PROJ_ID
FROM PROJECT_OWNER.PROJECT;
and execute it I get a result set back like expected… most of the time. Sometimes I get a “Toad for Data Analysis: ORA-00904: : invalid identifier” on the same query that executed just fine a few minutes prior.
The same thing happens with the Query Builder. If I drag the table over and reconstruct the same query and execute it, I get the same “Toad for Data Analysis: ORA-00904: : invalid identifier” error as before. When using the Query Builder I get the error nearly every time. However, sometimes the query works.
I am totally perplexed as to why I’m getting this intermittent error. Executing the query using the editor works about 95% of the time. However, executing the query via the Query Builder doesn’t work 95% of the time.
If anyone has any ideas, hints, clues, or solutions I’d love to hear them, because at this point I’m completely stuck.