Status shows 'Refreshing Invalid Result Set' while Fetching Rows
60779Aug 18 2008 — edited Aug 19 2008While scrolling forward or exporting the data returned in the Results pane, the status at the bottom left of the SQL Developer window toggles from showing the number of rows fetched to a message showing 'Refreshing Invalid Result Set'. After this happens, it looks like the fetch continues, with the row count starting at zero again, but SQL Developer subsequently goes into a hang condition. Does anyone have any idea why this is happening? The query runs fine in SQL*Plus. Thanks in advance.