Dba_errors
Oracle PL/SQL: SHOW ERRORS and dba_errors Explained
Mar 16, 2024 / · 9 min read · oracle plsql dba_errors user_errors all_errors all_plsql_object_settings dbms_warning ·Oracle PL/SQL: SHOW ERRORS and dba_errors Explained Purpose DBA_ERRORS is the data dictionary view that holds the current compilation errors for every stored object in the database. It is the first place to look when a procedure, function, package or trigger is created but does not work. The view describes the current …
Read MoreIdentify and Fix Invalid Objects in Oracle Database
How to Identify and Fix Invalid Objects in an Oracle Database Purpose A list of invalid objects tells you more than it first seems to. Ten invalid objects in one application schema right after a release can point to one changed table. Hundreds of invalid objects across many schemas more often follow a patch or an …
Read More