PLSQL_WARNINGS

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

Property	Description
Parameter type	String
Syntax	PLSQL_WARNINGS = 'value_clause [, 'value_clause' ] ...
Syntax	value_clause::= { ENABLE | DISABLE | ERROR }: { ALL | SEVERE | INFORMATIONAL | PERFORMANCE | { integer | (integer [, integer ] ...) } }
Default value	'DISABLE:ALL'
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No
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)';

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

See Also: Oracle AI Database PL/SQL Language Reference for more information about this parameter