Toad World® Forums

Query Builder ORA-00904


#1

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.


#2

Intermittent problems are a pain. I’m curious to know, if you were to execute the same query via SQL*Plus, do you receive the same intermittent success? It’s concerning that even while executing via the editor, the query seems to run only some of the time. If we take TDA out of the equation, what happens?