When I execute a package body DDL statement SQL Developer warns,
Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1
How can SQL Developer be configured to not use PLSQL_DEBUG?
PLSQL_DEBUG is set to false in an sql*plus session using the same connection details,
> show parameters plsql
NAME TYPE VALUE
------------------------------------ ----------- ------------------开发者_JAVA百科------------
plsql_ccflags string
plsql_code_type string INTERPRETED
plsql_debug boolean FALSE
plsql_native_library_dir string
plsql_native_library_subdir_count integer 0
plsql_optimize_level integer 2
plsql_v2_compatibility boolean FALSE
plsql_warnings string ENABLE:ALL
Oracle SQL Developer v 2.1.1.64
Oracle 11g SE: 11.1.0.6.0
I am looking for a GUI option not a login trigger to achieve this.
I am not looking for a way to simply suppress the display of this warning. The warning must not be generated at all.
If you only want to disable a single warning you can use PLSQL_WARNINGS. The oracle documentation for 11g can be found here
To disable the warning for your session the usage is:
ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL','DISABLE:06015';
However this will only disable for your current session. If you wanted it to be disabled whenever you login, you would need to add it to your login.sql file used with SQL Developer.
Alternatively I believe you can turn all PL/SQL compiler warnings off in SQL Developer (although i would not recommend this) Preferences->Database->PL/SQL Compiler Options
It may be possible to remove the plsql_debug parameter, but I am unsure how to do this. Maybe someone else can help here.
精彩评论