I have a couple of hundred update statements like the three here.
update Z_BB_OL_GURFEED_TBL set NWC_BUDGET_ADJUSTMENTS = 9425.58 where
fiscal_year = ‘2009’ and fiscal_period = ‘01’ and fund = ‘100000’ and
organization_code = ‘2050’ and account = ‘70100’ and program = ‘40’ and activity
= ‘’ ;
update Z_BB_OL_GURFEED_TBL set NWC_BUDGET_ADJUSTMENTS = 1468.5 where fiscal_year
= ‘2009’ and fiscal_period = ‘01’ and fund = ‘100000’ and organization_code =
‘2051’ and account = ‘70100’ and program = ‘10’ and activity = ‘’ ;
update Z_BB_OL_GURFEED_TBL set NWC_BUDGET_ADJUSTMENTS = - 7106 where fiscal_year
= ‘2009’ and fiscal_period = ‘01’ and fund = ‘100000’ and organization_code =
‘2090’ and account = ‘60120’ and program = ‘40’ and activity = ‘’ ;
If I highlight an individual line and press Shift/F9, it executes immediately
and quickly. If instead I click the “Execute as a script” icon with
lines highlighted or not, I get the following announcement.
The only thing that happens is that the Execution Time ticks on and on –
five minutes at last check. The whole thing should take less than five seconds.
L
What’s up?
Thanks much,
Dan
Daniel B Madvig
Computer Technologies
Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu
Did you Commit or Rollback after the shift-f9? If not, I wonder if Toad has
opened a separate thread/session for the f5, and that new session is waiting for
the f9 session to commit or rollback its update to the same row of the same
table.
Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
Did you Commit or Rollback after the shift-f9? If not, I wonder if Toad has
opened a separate thread/session for the f5, and that new session is waiting for
the f9 session to commit or rollback its update to the same row of the same
table.
Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
Also a possibility. If Options -> Oracle -> Transactions -> Execute scripts in
Toad session is unchecked, F5 will create a new session to execute the script
in.
Also a possibility. If Options -> Oracle -> Transactions -> Execute scripts in
Toad session is unchecked, F5 will create a new session to execute the script
in.