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 )
Debugger of Toad versions 9.7 and above queries from V$MYSTAT for the SID,regardless whether you answer 'Yes' or 'No' to compile referenced objects.
For Database versions less than 10gR2, Debugger of Toad versions 9.7 and above requires privilege to query the V$MYSTAT as it uses the below query:
SELECT SID FROM V$MYSTAT WHERE ROWNUM =1
For Database versions greater or equal to 10gR2, Debugger uses the below query:
SELECT USERENV(SID) FROM DUAL
Toad 9.6 and older, queries the V$SESSION and does not require privs to V$MYSTAT.
Execute the following statement to grant Select to the underlying view for all users in a database:
GRANT SELECT ON SYS.V_$MYSTAT TO PUBLIC;
OR
Grant SELECT_CATALOG_ROLE role to user.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center