execute as a script

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

651.631.5323

image001.png

image001.jpeg
image001.png

Is there a trigger on the table? It looks like the script engine is waiting for
Oracle to tell it that it’s ok to move to the next statement.

Greg
image001.jpeg

Is there a trigger on the table? It looks like the script engine is waiting for
Oracle to tell it that it’s ok to move to the next statement.

Greg
image001.png

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

314-694-2592
image001.jpeg

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

314-694-2592
image001.png

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.
image001.jpeg

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.
image001.png