ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL' : plsql_warnings « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. plsql_warnings

SQL>
SQL>
SQL>
SQL> ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'
  2  /

Session altered.

SQL> CREATE OR REPLACE PACKAGE plw5000
  2  IS
  3     TYPE collection_t IS TABLE OF VARCHAR2 (100);
  4
  5     PROCEDURE proc (collection_in IN OUT NOCOPY collection_t);
  6  END plw5000;
  7  /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY plw5000
  2  IS
  3     PROCEDURE proc (collection_in IN OUT collection_t)
  4     IS
  5     BEGIN
  6        DBMS_OUTPUT.PUT_LINE ('Hello!');
  7     END proc;
  8  END plw5000;
  9  /

SP2-0810: Package Body created with compilation warnings

SQL>
SQL> SHOW ERRORS PACKAGE BODY plw5000
Errors for PACKAGE BODY PLW5000:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/20     PLW-05000: mismatch in NOCOPY qualification between specification
         and body

3/20     PLW-07203: parameter 'COLLECTION_IN' may benefit from use of the
         NOCOPY compiler hint

SQL>