Toad for Oracle Base Edition (64-bit)
Add-Ons:
17.1.717.3711
Create a package with a procedure that returns a sys_refcursor.
Use "Execute package" option
In "Output Options" tab, check "Fetch into memory (view in grid)" and execute with "OK" button.
The window "PL/SQL results" opens. Double click the cell labeled with "(CURSOR)" to view the fetched records.
Right click and select "Record Count" :
The modal window gets frozen on top of every other window in the system. Toad gets also frozen so, you need kill it with task manager.
Thanks. I can reproduce this. It will be fixed in the next beta, and in version 2025 R3.
The problem is that that cursor output window is on top of the record count window.
You can do the following instead of killing Toad with task manager:
After you've right-clicked on "Record Count" and can't get to it, do an Alt+Space on the keyboard. Then hit the M key. Now you can hold the right or left arrow key to move the record count window out from behind the cursor output window.
This is a generic trick for any window that's stuck behind another. You can practice it with a window that is visible.
1 Like
Thats right! Thank you very much!
Now that I know the reason, I'll configure the window to remember its size and position on the side of the screen to prevent it from floating over the others (and therefore the counting window). But is this a bug, or can it be configured so that this window doesn't float and cover all the others?
Edited: Unfortunately, it seems that position retention doesn't work, although size retention does. Even though both options are selected in the window settings, the floating window with the cursor always appears in the center of the screen, so there's no solution.
This is a bug and it will be fixed in the beta released on Monday.
If you can't upgrade, you can at least use the Alt+Space, M, Arrow key trick.