1)Which object error messages goes to this user_errors table(i.e whether all data object error messages goes to this table or only particular objects like functions or procedures)
2)WheHow many messages does it store at maximum?
Printable View
1)Which object error messages goes to this user_errors table(i.e whether all data object error messages goes to this table or only particular objects like functions or procedures)
2)WheHow many messages does it store at maximum?
USER_ERRORS describes current errors on all stored objects
(views, procedures, functions, packages, and package bodies)
owned by the current user
ALL_ERRORS describes current errors on all stored objects
(views, procedures, functions, packages, and package bodies)
accessible to the current user
DBA_ERRORS describes all current errors on all views, procedures, functions, packages, and
package bodies in the database.