Getting error "ora-00942 " when trying to access to the data of a view.
This only happens when "execute queries on threads" is checked.
Please find below the steps to reproduce this.
1) Run the script below
create table t_test (n number);
insert into t_test values (1);
insert into t_test values(2);
insert into t_test values(3);
commit;
create edition ed1 as child of ora$base;
grant use on edition ed1 to public;
alter session set edition =ed1;
create view v_test as select * from t_test;
2)Make sure the option “execute queries in threads” is checked in View |Toad options:
Open a Schema Browser
Go to editions tab
Select ed1 , r – click and select “set as current session edition”
Go to Views tab
Select v_test view
Go to Data tab: instead of the data , Toad sends an ora-00942 error.
If option “execute queries in threads” is unchecked then it works.
WORKAROUND
Do not use threaded queries when setting the current edition at the session level.
STATUS
Waiting for fix in a future release of Toad for Oracle
