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 ...

Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.