Toad for Oracle Base Edition (64-bit)
17.1.717.3711
When executing a procedure that returns a sys_recordset as an output parameter, if the cursor is fetched into memory, the "PL/SQL Results" screen is displayed upon completion. Inspecting the cursor's contents opens a modal window showing its contents.
The problem is that this window is modal, as are its parent window and its grandparent window (TOAD itself), rendering all other application windows inaccessible or severely limiting their screen space. Minimizing the window allows access to other windows, but their contents are then difficult to compare with those of other applications.
Is there any way to prevent this window from being so modal?
Unless I am missing something, the cursor output dialog (what you get after double-clicking on a (CURSOR) cell) is the only thing that modal. Here, I arranged the pl/sql results window side-by-side with schema browser before double-clicking on the (CURSOR) cell.
You're right: only the window displaying the cursor is modal, but when it receives focus when selected with the cursor, Toad's main window also activates and covers any other windows unrelated to Toad. So, even if the window displaying the cursor is small, it's not possible to resize the main window to make room for other windows without first closing the modal. Therefore, it's necessary to plan the size and placement of the windows before opening the modal.
I think what you're proposing would improve usability in these situations.
Ok, it is done. Version 2026R1, as well as the next beta (to be released on Monday Dec 1) will show the cursor output grid at the bottom of the window, like this.
