Toad World® Forums

Problem with large number of result/output panes (I think)


#1

Hello, if I enter the “script” (far) below in the code editor, select all the lines and execute (F9) them, SQLNav (6.2.0.1250) creates a bunch of “Result” panes (one for each select statement).
If I then go back to the code editor, reselect all the lines and re-execute (F9) them, SQLNav will either display the dreaded “SQL Navigator for Oracle has encountered a problem and needs to close. We are sorry for the inconvenience.” dialog or display the line “Internal error occurred; see file ERROR.LOG for details” in the output window and stop processing (tried against 9.2.0.7 and 10.2.0.4 Oracle DB).
In the latter case, the task is still running, according to the Task Manager, and it can be stopped by the “Stop Script Execution” button (BTW: the assigned shortcut key “Scroll Lock” does not seem to work?).

The “script”:

SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;
SELECT * FROM DUAL;


#2

Hi Dominique,

Thanks for pointing it out. This will be fixed ASAP.

Gwen