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>