Error: "ORA-00942 :Table or view does not exist" is returned when debugging a PL/SQL procedure in Toad 9.7.2.
Debugging same procedure in 9.6 works fine.
See below for my comparison between 9.6 and 9.7.
TOAD 9.7 (ERROR)
----------------------------------
Timestamp: 16:40:24.291
Successful logon attempt (session tag: 0x3BFFE48)
username: REE; database: IO3
----------------------------------
Timestamp: 16:40:24.300
SELECT SID FROM V$MYSTAT WHERE ROWNUM =1
Runtime error occurred: 942 (ORA-00942: table or view does not exist)
----------------------------------
Timestamp: 16:40:25.843
select sid from V$SESSION where audsid = ( select USERENV(SESSIONID) from
dual )Runtime error occurred: 942 (ORA-00942: table or view does not exist)
TOAD 9.6 (WORKS FINE)
----------------------------------
Timestamp: 16:32:00.804
Successful logon attempt (session tag: 0x82A079C)
username: REE; database: IO3
----------------------------------
Timestamp: 16:32:00.820
select sid from V$SESSION where audsid = ( select USERENV(SESSIONID) from dual )
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center