Errors:

Runtime errors obtain from design faults, mistakes, hardware failures and several other sources. While these errors are not anticipated then these errors can be handled meaningfully. To capture the errors raised and Exceptions are used. Within PL/SQL, warnings or error condition is known as Exception. When an error occurs the exception is raised. That is general execution is stopped and control is transferred to the exception-handling category of the PL/SQL block. It is designed for run-time rather than compile time errors. These are handled in the Exception section of the PL/SQL block. Errors can be categorized as

• Runtime Errors
• Compile-time Errors

Exceptions can be widely categorized into:

• Predefined Exceptions
• User-defined Exceptions
• Un-defined Exceptions