After the initial installation or reinstallation of Toad, "Execute scripts in Toad session" option does not seem to be applied correctly when first starting up Toad. The script does not seem to be executed in the Toad session.
Toad Options > Oracle > Transactions | Execute scripts in Toad session
This option is checked by default. But Toad runs in the SQL Editor as if this option was unchecked. If you go into Options and click OK button without changing any option, and go back into Editor to run something agian, it will run as expected with script executing in Toad session.
Steps to replicate/test:
drop table t1;
create table t1 (c1 varchar2(10));
-- Use 'F9' button
insert into t1 (c1) values ('F9');
-- Use 'F5' button (drag your mouse to select following two insert statement and execte(F5))
insert into t1 (c1) values ('F5');
insert into t1 (c1) values ('F5');
select * from t1;
/*** result ***
C1
--
F9
*/
commit;
select * from t1;
/*** result ***
C1
--
F5
F5
F9
*/
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center