Types of Exceptions.

Types of Exceptions:
1) Predefined Exception.
2) User-defined Exception.

1) Predefined Exception:

• Oracle has predefined several exceptions that correspond to the most common oracle errors.
• A predefined oracle server error is trapped by referencing its standard name within the corresponding exception handling at runtime.
• As soon as the Exception occurs oracle implicitly raise the exception and jumps into the EXCEPTION handle block, if proper EXCEPTION handle is found manages the specified steps.
• In predefined oracle server exceptions only one exception is raised and handled at any time.

2) User-defined Exception:

• A user-defined exception is an error that is defined by the program.
• The developers to handle the business situations define user-defined exceptions during the execution of the PL/SQL block.