SQL Developer not providing query results.
713678Jul 24 2009 — edited Sep 29 2011I am having a weird problem. I have one query which provides me some records from my database (approx 700-800 rows). I use Oracle Sql developer or Toad as database tool, the problem is with the results. When I run the same query directly on sqlplus prompt then it displays complete results, therefore I can say that query has no problem. But when I run the same query with SQL Developer then it does not provide me any result, and shows status as processing for long time. Please help me I am running on Oracle 10g.