Did you try running the query on the sqlprompt. IF not try that and could you post the status of the issue. Though they say ORA-6000 need to be reported, they aren't that fatel to panic. Lets see what happens when you get to execute the query on the sqlplus. Might be a poor design of query.

Sam