PLSQL_WARNINGS

Property	Description
Parameter type	String
Syntax	PLSQL_WARNINGS = 'value_clause' [, 'value_clause' ] ...
	value_clause::= value_clause::= { ENABLE | DISABLE | ERROR }: { ALL | SEVERE | INFORMATIONAL | PERFORMANCE | { integer | (integer [, integer ] ...) } }
Default value	'DISABLE:ALL'
Modifiable	ALTER SESSION, ALTER SYSTEM
Examples	PLSQL_WARNINGS = 'ENABLE:SEVERE', 'DISABLE:INFORMATIONAL'; PLSQL_WARNINGS = 'DISABLE:ALL'; PLSQL_WARNINGS = 'DISABLE:5000', 'ENABLE:5001', 'ERROR:5002'; PLSQL_WARNINGS = 'ENABLE:(5000,5001,5002)', 'DISABLE:(6000,6001)';

PLSQL_WARNINGS enables or disables the reporting of warning messages by the PL/SQL compiler, and specifies which warning messages to show as errors.

value_clause

Multiple value clauses may be specified, enclosed in quotes and separated by commas. Each value clause is composed of a qualifier, a colon (:), and a modifier.

Qualifier values:

· ENABLE

Enable a specific warning or a set of warnings

· DISABLE

Disable a specific warning or a set of warnings

· ERROR

Treat a specific warning or a set of warnings as errors

Modifier values:

· ALL

Apply the qualifier to all warning messages

· SEVERE

Apply the qualifier to only those warning messages in the SEVERE category

· INFORMATIONAL

Apply the qualifier to only those warning messages in the INFORMATIONAL category

· PERFORMANCE

Apply the qualifier to only those warning messages in the PERFORMANCE category

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘PLSQL_WARNINGS’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
plsql_warnings	DISABLE:ALL	TRUE	TRUE	IMMEDIATE	TRUE		FALSE	PL/SQL compiler warnings settings

Oracle initializatoin parameters