Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E16760-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

156 DBMS_WARNING

The DBMS_WARNING package provides a way to manipulate the behavior of PL/SQL warning messages, in particular by reading and changing the setting of the PLSQL_WARNINGS initialization parameter to control what kinds of warnings are suppressed, displayed, or treated as errors. This package provides the interface to query, modify and delete current system or session settings.

This chapter contains the following topics:


Using DBMS_WARNING


Security Model

Note that for all the following interfaces, if value of the scope parameter is SYSTEM, then the user must have ALTER SYSTEM privilege.


Summary of DBMS_WARNING Subprograms

Table 156-1 DBMS_WARNING Package Subprograms

Subprogram Description

ADD_WARNING_SETTING_CAT Procedure

Modifies the current session or system warning settings of the warning_category previously supplied

ADD_WARNING_SETTING_NUM Procedure

Modifies the current session or system warning settings of the or warning_number previously supplied

GET_CATEGORY Function

Returns the category name, given the message number

GET_WARNING_SETTING_CAT Function

Returns the specific warning category in the session

GET_WARNING_SETTING_NUM Function

Returns the specific warning number in the session

GET_WARNING_SETTING_STRING Function

Returns the entire warning string for the current session

SET_WARNING_SETTING_STRING Procedure

Replaces previous settings with the new value



ADD_WARNING_SETTING_CAT Procedure

You can modify the current session's or system's warning settings with the value supplied. The value will be added to the existing parameter setting if the value for the warning_category or warning_value has not been set, or override the existing value. The effect of calling this function is same as adding the qualifier (ENABLE/DISABLE/ERROR) on the category specified to the end of the current session or system setting.

Syntax

DBMS_WARNING.ADD_WARNING_SETTING_CAT (
   warning_category    IN    VARCHAR2,
   warning_value       IN    VARCHAR2,
   scope               IN    VARCHAR2);

Parameters

Table 156-2 ADD_WARNING_SETTING_CAT Procedure Parameters

Parameter Description

warning_category

Name of the category. Allowed values are ALL, INFORMATIONAL, SEVERE and PERFORMANCE.

warning_value

Value for the category. Allowed values are ENABLE, DISABLE, and ERROR.

scope

Specifies if the changes are being performed in the session context or the system context. Allowed values are SESSION or SYSTEM.



ADD_WARNING_SETTING_NUM Procedure

You can modify the current session or system warning settings with the value supplied. If the value was already set, you will override the existing value. The effect of calling this function is same as adding the qualifier (ENABLE / DISABLE/ ERROR) on the category specified to the end of the current session or system setting.

Syntax

DBMS_WARNING.ADD_WARNING_SETTING_NUM (
   warning_number      IN    NUMBER,
   warning_value       IN    VARCHAR2,
   scope               IN    VARCHAR2);

Parameters

Table 156-3 ADD_WARNING_SETTING_NUM Procedure Parameters

Parameter Description

warning_number

The warning number. Allowed values are all valid warning numbers.

warning_value

Value for the category. Allowed values are ENABLE, DISABLE, and ERROR.

scope

Specifies if the changes are being performed in the session context or the system context. Allowed values are SESSION or SYSTEM.



GET_CATEGORY Function

This function returns the category name, given the message number.

Syntax

DBMS_WARNING.GET_CATEGORY (
   warning_number  IN   pls_integer) 
RETURN VARCHAR2;

Parameters

Table 156-4 GET_CATEGORY Function Parameters

Parameter Description

warning_number

The warning message number.



GET_WARNING_SETTING_CAT Function

This function returns the specific warning category setting for the current session.

Syntax

DBMS_WARNING.GET_WARNING_SETTING_CAT (
   warning_category    IN    VARCHAR2)
RETURN warning_value;

Parameters

Table 156-5 GET_WARNING_SETTING_CAT Function Parameters

Parameter Description

warning_category

Name of the category. Allowed values are all valid category names (ALL, INFORMATIONAL, SEVERE and PERFORMANCE).



GET_WARNING_SETTING_NUM Function

This function returns the specific warning number setting for the current session.

Syntax

DBMS_WARNING.GET_WARNING_SETTING_NUM (
   warning_number      IN    NUMBER)
RETURN warning_value;

Parameters

Table 156-6 GET_WARNING_SETTING_NUM Function Parameters

Parameter Description

warning_number

Warning number. Allowed values are all valid warning numbers.



GET_WARNING_SETTING_STRING Function

This function returns the entire warning string for the current session.

Syntax

DBMS_WARNING.GET_WARNING_SETTING_STRING
 RETURN pls_integer;

Usage Notes

Use this function when you do not have SELECT privilege on v$parameter or v$paramater2 fixed tables, or if you want to parse the warning string yourself and then modify and set the new value using SET_WARNING_SETTING_STRING.


SET_WARNING_SETTING_STRING Procedure

This procedureS replaces previous settings with the new value. The warning string may contain mix of category and warning numbers using the same syntax as used on the right hand side of '=' when issuing an ALTER SESSION or SYSTEM SET PLSQL_WARNINGS command. This will have same effect as ALTER SESSION OR ALTER SYSTEM command.

Syntax

DBMS_WARNING.SET_WARNING_SETTING_STRING (
   warning_value   IN   VARCHAR2,
   scope           IN   VARCHAR2);

Parameters

Table 156-7 SET_WARNING_SETTING_STRING Procedure Parameters

Parameter Description

warning_value

The new string that will constitute the new value.

scope

This will specify if the changes are being done in the session context, or system context. Allowed values are SESSION or SYSTEM.