Oracle教程

Oracle 参数 PLSQL_WARNINGS 官方解释，作用，如何配置最优化建议

本站中文解释

PLSQL_WARNINGS是控制PL/SQL代码中一些编译和运行时警告信息的参数，可以通过设置这个参数来区分警告来显示警告，禁止警告，只留下注意警告，或者关闭警告消息这几种情况。

正确的设置方式：

1. 进入SQL*Plus环境，在提示符后输入“ alter system set PLSQL_WARNINGS=enable；”命令，使警告消息正确显示；

2. 也可以通过SQL命令“create or replace procedure procedure_name is begin null; end;”来设置警告消息显示，在这种情况下，执行过程中会有警告信息出现；

3. 如果想要只保留注意警告，可以使用“alter system set PLSQL_WARNINGS=defer；”命令；

4. 最后，如果需要完全禁用警告消息，可以使用“alter system set PLSQL_WARNINGS=off；”命令，这会导致所有的警告消息在会话期间被完全忽略。

官方英文解释

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 Database PL/SQL
Language Reference for more information about this parameter


数据运维技术 » Oracle 参数 PLSQL_WARNINGS 官方解释，作用，如何配置最优化建议
分享到：

相关推荐