ALL_WARNING_SETTINGS

ALL_WARNING_SETTINGS displays information about the warning parameter settings for the objects accessible to the current user.

Related Views

  • DBA_WARNING_SETTINGS displays information about the warning parameter settings for all objects in the database.

  • USER_WARNING_SETTINGS displays information about the warning parameter settings for the objects owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the object
OBJECT_NAME VARCHAR2(30) NOT NULL Name of the object
OBJECT_ID NUMBER NOT NULL Object number of the object
OBJECT_TYPE VARCHAR2(12)   Type of the object:

  • PROCEDURE

  • FUNCTION

  • PACKAGE

  • PACKAGE BODY

  • TRIGGER

  • TYPE

  • TYPE BODY
WARNING VARCHAR2(40)   Warning number or category:

  • INFORMATIONAL

  • PERFORMANCE

  • SEVERE

  • ALL
SETTING VARCHAR2(7)   Value of the warning setting:

  • DISABLE

  • ENABLE

  • ERROR

See Also: