Skip to main content

Overview

Special conditions may occur during the execution of stored programs and require handling, such as exiting the current program block. Users can define handlers for conditions like warnings or exceptions or specify error codes.

seekdb supports the following PL exception handling statements:

  • The DECLARE ... CONDITION statement is used to name an exception condition. For more information, see DECLARE ... CONDITION.

  • The DECLARE ... HANDLER statement is used to declare a handler. For more information, see DECLARE ... HANDLER.

  • The RESIGNAL statement is used to modify the exception information in the handler. For more information, see RESIGNAL.

  • The SIGNAL statement is used to raise an exception condition. For more information, see SIGNAL.

  • The GET DIAGNOSTICS statement is used to retrieve information from the diagnostic area. For more information, see GET DIAGNOSTICS.

Information on how the server selects a handler when an exception condition occurs. For more information, see Handler Scope.

For information about the diagnostic area, see Diagnostic Area.