plw5001.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 29 行

CREATE OR REPLACE PROCEDURE plw5001
IS
   a   BOOLEAN;
   a   PLS_INTEGER;
BEGIN
   a := 1;   
   DBMS_OUTPUT.put_line ('Will not compile?');
END plw5001;
/

SHOW ERRORS

ALTER SESSION SET plsql_warnings = 'disable:all'
/

CREATE OR REPLACE PROCEDURE plw5001
IS
   a   BOOLEAN;
   a   PLS_INTEGER;
BEGIN
   DBMS_OUTPUT.put_line ('Will not compile?');
END plw5001;
/

ALTER PROCEDURE plw5001 COMPILE plsql_warnings = 'enable:all'
/

SHOW ERRORS