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.
| Property | Description |
|---|---|
| Type | varchar |
| Default value | ENABLE:ALL |
| Value range | Standard strings |
| Effective upon OBServer node restart | No |
The following syntax is used:
PLSQL_WARNINGS = 'value_clause' [, 'value_clause' ]
value_clause::=
{ ENABLE | DISABLE | ERROR }:
{ ALL
| WARN
| DEBUG
| { integer
| (integer [, integer ] ...)
}
}
The parameters are described as follows:
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 are some examples:
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)';