Condition Handler Types - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
vqj1592443206677.ditamap
dita:ditavalPath
vqj1592443206677.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantageā„¢
You must specify one of the following handler types in a handler declaration:
  • CONTINUE
  • EXIT

When a stored procedure encounters a condition, the specified handler action is executed regardless of the handler type specified.

The difference is that CONTINUE passes control to the next statement within the compound statement, and EXIT passes control to the next statement outside the compound statement that contains the handler.

The behavior of CONTINUE and EXIT handlers is described in DECLARE HANDLER (CONTINUE Type) and DECLARE HANDLER (EXIT Type).