plsql_warnings的问题

深圳－刀

SQL> alter session set plsql_warnings='disable:ALL';
Session altered.
SQL> alter package pkg_tools compile;
Package altered.
SQL> show errors;
No errors.
程序原本是没有错误的。查看WARNING：

SQL> alter session set plsql_warnings='error:performance';
Session altered.
SQL> alter package pkg_tools compile;
Warning: Package altered with compilation errors.
SQL> show errors;
Errors for PACKAGE PKG_TOOLS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/30    PLS-07203: parameter 'PO_V_RETDESC' may benefit from use of the
         NOCOPY compiler hint
PERFORMANCE的WARNING显示正常。

SQL> alter session set plsql_warnings='error:INFORMATIONAL';
Session altered.
SQL> alter package pkg_tools compile;
Warning: Package altered with compilation errors.
SQL> show errors;
No errors.
INFORMATIONAL的WARNING显示不出来。

Maclean Liu(刘相兵

是否能使用  PLSQL_WARNINGS='ENABLE:ALL';？

error:INFORMATIONAL 这个组合很少见

深圳－刀

SQL> alter session set plsql_warnings='ENABLE:ALL';
Session altered.
SQL> alter package pkg_tools compile;
SP2-0809: Package altered with compilation warnings
SQL> show errors;
Errors for PACKAGE PKG_TOOLS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/30    PLW-07203: parameter 'PO_V_RETDESC' may benefit from use of the
         NOCOPY compiler hint
查ALL的话，还是只有07203一个，我主要想知道除了performance之外，还有哪些的WARNING？
难道没有其他WARNING了，其他“Warning: Package altered with compilation errors.”是误报？