Examples of Declare Condition
1. Declare a condition named “zero_divide” for the SQLSTATE 22012 error.:
DECLARE zero_divide CONDITION FOR SQLSTATE '22012';
2. Declare a condition named “string_conversion” for DBMS error code E_US100F:
DECLARE string_conversion CONDITION FOR DBMSERROR 'E_US100F';
3. Declare a condition using a user-defined condition name:
DECLARE LOGIC_ERROR CONDITION;
Permissions
This statement is available to all users.
Last modified date: 12/19/2024