Condition Handler Types - Teradata Vantage - Analytics Database

SQL Stored Procedures and Embedded SQL

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
frc1628111662093.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
rjx1472253414573
lifecycle
latest
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).