This chapter covers PL/SQL error management.
Two types of PL/SQL errors exist: those that happen at compilation time (also known as syntax errors or compile-time errors) and those that happen at runtime (also known as semantic errors). You will see compilation errors in both anonymous and named blocks—functions, procedures, packages, or user-defined object types. Compilation errors are easier to find because Oracle immediately alerts you when it comes across syntax errors. Semantic errors occur as a result of bad logic in your program, and they can be very subtle. In some cases, only a keen eye catches them before runtime. ...