plsql_warnings controls the error reporting behavior of the PL/SQL compiler. You can use this parameter to specify the status of a warning code or a type of warning codes as enable, disable, or error.
| Attribute | Description |
|---|---|
| Type | varchar |
| Default value | ENABLE:ALL |
| Value range | Standard strings |
| Effective upon OBServer node restart | No |
The syntax is as follows:
PLSQL_WARNINGS = 'value_clause' [, 'value_clause' ]
value_clause::=
{ ENABLE | DISABLE | ERROR }:
{ ALL
| WARN
| DEBUG
| { integer
| (integer [, integer ] ...)
}
}
value_clause has the following valid values:
ENABLE: enable the specified warnings.DISABLE: disable the specified warnings.ERROR: treat the specified warnings as errors.ALL: apply to all warning messages.DEBUG: apply to debugging.WARN: apply to warnings.
Here is an example:
PLSQL_WARNINGS = 'ENABLE:DEBUG', 'DISABLE:WARN';
PLSQL_WARNINGS = 'DISABLE:ALL';
PLSQL_WARNINGS = 'DISABLE:5000', 'ENABLE:5001','ERROR:5002';
PLSQL_WARNINGS = 'ENABLE:(5000,5001,5002)','DISABLE:(6000,6001)';