All errors › ORA errors
ORA-00942: Table or view does not exist
What it means
The object is missing, is in another schema, or you do not have a privilege on it (Oracle reports missing privileges as "does not exist" so it does not reveal the object). In PL/SQL, privileges granted through a role are not visible inside definer-rights stored code.
How to fix it
Check ALL_OBJECTS for the name and owner, prefix it with the schema or create a synonym, and grant SELECT/INSERT/... directly to the user (not through a role) when the object is used inside a procedure or package. Watch for quoted lower-case table names.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.