9-10. Displaying PL/SQL Compiler Warnings


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.


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.