How to prevent "PLSQL_DEBUG parameter is deprecated" compiler warning in Oracle SQL Developer

When I execute the DDL statement of the body package, the SQL developer warns

Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1

How can SQL Developer be configured to use PLSQL_DEBUG?

PLSQL_DEBUG is false in a sql * plus session using the same connection information,

> show parameters plsql

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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 for this.

I am not looking for a way to simply suppress the display of this warning. A warning should not be generated at all.

+5
source share
1 answer

, PLSQL_WARNINGS. 11g

, :

ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL','DISABLE:06015';

. , , , login.sql, SQL Developer.

, , PL/SQL SQL Developer ( ) - > - > PL/SQL

, plsql_debug, , . , - .

+2

All Articles