I am using Toad 220.127.116.11 on Oracle 10g. When i am running a select * on hr_pump_batch_lines (one of the tables in Oracle R12) i am getting “Out of Memory” Error. There is no other messages on the error window. I can continue working normally after this, it happens only when i query this table.
I can see the data if i use F4 and goto Data tab. The table has only 50 rows in it. The error happens even if i add a where clause to it. I can query the table from SQL Developer.
Why this is happening and is there a solution? I really dont want to jump back and forth in tools and i really like Toad.