Oracle and PL/SQL Recipes: A Problem-Solution Approach

9-10. Displaying PL/SQL Compiler Warnings

Problem

You are interested in making your code more robust by ensuring that no issues will crop up as time goes by and the code evolves. You want to have the PL/SQL compiler alert you of possible issues with your code.

Solution

Use PL/SQL compile-time warnings to alert you of possible issues with your code. Enable warnings for your current session by issuing the proper ALTER SESSION statements or by using the DBMS_WARNING package to do so. This solution will demonstrate each of these techniques to help you decide which will work best for your debugging purposes.

First let's take a look at using ALTER SESSION to enable and configure warnings for your environment. This technique can be very useful when ...