Use Compile-Time Warnings to Detect Runtime Errors

View All Scripts Login to Run Script

Script Name Use Compile-Time Warnings to Detect Runtime Errors
Description This is one of my favorite warnings: PLW-6017. Something bad is your way coming! This catch-all warning is flagged when the compiler that at run-time, your code will raise an exception. Very cool! You might ask: why isn't this a compile-time ERROR? Well, maybe the developer is deliberately raising an exception for some reason?
Area PL/SQL General
Contributor Steven Feuerstein
Created Wednesday February 21, 2018

Statement 1

ALTER SESSION SET plsql_warnings = 'enable:all'

Statement processed.

Statement 2

CREATE OR REPLACE PROCEDURE plw6017 
   AUTHID CURRENT_USER 
IS 
   c   VARCHAR2 (1) := 'abc'; 
   n   NUMBER; 
BEGIN 
   n := 1 / 0; 
END;

Warning: PROCEDURE PLW6017
Line: 4 PLW-06017: an operation will raise an exception
Line: 7 PLW-06017: an operation will raise an exception
Line: 7 PLW-06002: Unreachable code

More Details: https://docs.oracle.com/error-help/db/ora-20001

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database