Running select statement within cursor creates variables that are not in code
説明
If a procedure is open and a cursor in the DECLARE section, there is a problem when trying to run just that select statement. Pressing CTL+ENTER or SHIFT+F9, an 'Edit SQL' window pops up. Once 'OK' is clicked on the Edit SQL tab, it goes to a 'variables' window where it is supposed to list all variables needing an input on the left. Instead of just listing the variables, it is taking all the table aliases, adding numbers to the end of them, and listing them as variables as well. This leads to false & null results in the data grid.
対策
WORKAROUND: None
STATUS: Waiting for fix to be released in a future version of Toad for Oracle.
Defect ID
ST109618
追加情報
Currently fixed in 12.5 Beta. This is planned for the next release of Toad, barring any conflict between now and the commercial release of Toad for Oracle.
