1.268 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 |
|
Syntax |
value_clause::=
|
Default value |
|
Modifiable |
|
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 Database PL/SQL Language Reference for more information about this parameter