Oracle PL/SQL Tutorial/SQL PLUS Session Environment/plsql warnings

Материал из SQL эксперт
Перейти к: навигация, поиск

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>