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