December 2002
Intermediate to advanced
928 pages
85h 29m
English
PL/SQL allows developers to raise and handle errors (exceptions) in a very flexible and powerful way. Each PL/SQL block can have its own exception section in which exceptions can be trapped and handled. When an exception is raised in a PL/SQL block, its execution section immediately terminates. Control is passed to the exception section. Every exception in PL/SQL has an error number and error message; some exceptions also have names.
When an exception occurs (or is raised), the control leaves the execution section and passes directly to the exception section of your PL/SQL block. If the exception is not handled by the exception section, control leaves the block.