It’s likely waiting to parse. Executing requires knowledge of the statements and 370k statements is a lot to digest. Has the Navigator populated yet? After parsing it should execute without issue.
There was a somewhat recent thread about fast edit/execute cycles that is related. I have it logged to investigate, but I need more than a summer release cycle to look at it.
On Sep 20, 2017, at 2:36 AM, kornelis.abe firstname.lastname@example.org wrote:
Toad Hang on F9
Thread created by kornelis.abe
This relates to Toad for Oracle, Beta 18.104.22.168
I have a simple SQL statement that generates insert and update statements - just over 370,000 of them.
So I run the query, export the result column, paste that into a separate editor window on a different connection.
Then I select the first statement, which happens to be an update statement, and hit F9 in order to test the generated update statement.
Toad goes into a hang. In the lower right corner the progress bar does not show anything in progress.
Inserting a blank line in between the highlighted statement and the rest of the script makes no difference.
Also, Ctrl-Enter behaves the same as F9: Toad hangs and shows no progress at all.
Is this a known issue?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
this post as spam/abuse.