Completion, Exception, and User-defined Condition Handlers - 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ā„¢
Stored procedures support completion condition, exception condition, and user-defined condition handlers of the CONTINUE and EXIT types, including:
  • SQLSTATE-based condition handlers
  • Generic exception condition handler for SQLEXCEPTION conditions
  • Generic completion condition handlers for SQLWARNING and NOT FOUND conditions
  • Condition handlers for user-defined conditions

Related Information

For more information about condition handling in stored procedures, see Condition Handling.