Set the PLSQL_WARNING level to DISABLE:ALL : Compile Error « PL SQL « Oracle PL / SQL






Set the PLSQL_WARNING level to DISABLE:ALL

    
SQL> CREATE TABLE books (
  2    isbn      CHAR(10) PRIMARY KEY,
  3    category  VARCHAR2(20),
  4    title     VARCHAR2(100),
  5    num_pages NUMBER,
  6    price     NUMBER,
  7    copyright NUMBER(4),
  8    emp1   NUMBER,
  9    emp2   NUMBER,
 10    emp3   NUMBER
 11  );

Table created.

SQL>
SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2, emp3)
  2             VALUES ('1', 'Database', 'Oracle', 563, 39.99, 2009, 1, 2, 3);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2)
  2             VALUES ('2', 'Database', 'MySQL', 765, 44.99, 2009, 4, 5);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2, emp3)
  2             VALUES ('3', 'Database', 'SQL Server', 404, 39.99, 2001, 6, 7, 8);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2, emp3)
  2             VALUES ('4', 'Database', 'SQL', 535, 39.99, 2002, 4, 5, 9);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2)
  2             VALUES ('5', 'Database', 'Java', 487, 39.99, 2002, 10, 11);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2)
  2             VALUES ('6', 'Database', 'JDBC', 592, 39.99, 2002, 12, 13);

1 row created.

SQL> INSERT INTO books (isbn, category, title, num_pages, price, copyright, emp1, emp2, emp3)
  2             VALUES ('7', 'Database', 'XML', 500, 39.99, 2002, 1, 2, 3);

1 row created.

SQL>

SQL> CALL DBMS_WARNING.SET_WARNING_SETTING_STRING('DISABLE:ALL', 'SESSION');

Call completed.

SQL>
SQL> CREATE OR REPLACE PROCEDURE compile_warning
  2  AS
  3     v_title VARCHAR2(100);
  4     CURSOR dbms_warning_cur IS SELECT title FROM books;
  5  BEGIN
  6     OPEN dbms_warning_cur;
  7     LOOP
  8     FETCH dbms_warning_cur INTO v_title;
  9         DBMS_OUTPUT.PUT_LINE('Titles Available: '||v_title);
 10     END LOOP;
 11     CLOSE dbms_warning_cur;
 12  END;
 13  /

Procedure created.

SQL>
SQL>
SQL> drop table books;

Table dropped.

SQL>

   
    
    
    
  








Related examples in the same category

1.Check the error
2.Check error for procedure
3.Check error form stored procedure
4.PLS-00306: wrong number or types of arguments in call
5.PLS-00363: expression '3' cannot be used as an assignment target
6.This example illustrates the PLS-483 error
7.This package will not compile because the specification and body do not match.
8.Build an anonymous block that will trigger an error.
9.how DDL doesn't work with PL/SQL