New PL/SQL Compiler Warning in Oracle 11g

0 0

The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error.

SQL> alter session set plsql_warnings='enable:all';

Session altered.

SQL> create or replace procedure testje as
2  begin
3    dbms_output.put_line('why do something?');
4  exception
5    when others
6    then
7      null;
8    end;
9  /

SP2-0804: Procedure created with compilation warnings

SQL> sho err
Errors for PROCEDURE TESTJE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/8      PLW-06009: procedure "TESTJE" OTHERS handler does not end in
RAISE or RAISE_APPLICATION_ERROR 

About Post Author

Jurgen Kemmelings

Oracle consultant at AMIS

Jurgen.Kemmelings@amis.nl

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005 Death of the End Date – How LAG and LEAD help fight redundancy PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving Oracle 11g for Developers – presenting at Oracle Benelux User Group Conference 2007 Oracle Open World / Java One Preview bij AMIS