Oracle PL/SQL Tutorial/SQL PLUS Session Environment/plsql warnings
ALTER SESSION SET plsql_warnings = "disable:all"
<source lang="sql">
SQL> SQL> CREATE OR REPLACE PROCEDURE plw5001
2 IS 3 a BOOLEAN; 4 a PLS_INTEGER; 5 BEGIN 6 a := 1; 7 DBMS_OUTPUT.put_line ("Will not compile?"); 8 END plw5001; 9 /
Warning: Procedure created with compilation errors. SQL> SQL> SHOW ERRORS Errors for PROCEDURE PLW5001: LINE/COL ERROR
-----------------------------------------------------------------
4/4 PLW-05001: previous use of "A" (at line 3) conflicts with this
use
6/4 PL/SQL: Statement ignored 6/4 PLS-00371: at most one declaration for "A" is permitted SQL> SQL> ALTER SESSION SET plsql_warnings = "disable:all"
2 /
Session altered. SQL> SQL> CREATE OR REPLACE PROCEDURE plw5001
2 IS 3 a BOOLEAN; 4 a PLS_INTEGER; 5 BEGIN 6 DBMS_OUTPUT.put_line ("Will not compile?"); 7 END plw5001; 8 /
Procedure created. SQL> SQL> ALTER PROCEDURE plw5001 COMPILE plsql_warnings = "enable:all"
2 /
SP2-0805: Procedure altered with compilation warnings SQL> SQL> SHOW ERRORS Errors for PROCEDURE PLW5001: LINE/COL ERROR
-----------------------------------------------------------------
4/4 PLW-05001: previous use of "A" (at line 3) conflicts with this
use
SQL> SQL></source>
ALTER SESSION SET PLSQL_WARNINGS = "ENABLE:ALL"
<source lang="sql">
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></source>