-435 AN INVALID SQLSTATE sqlstate IS SPECIFIED IN A RAISE_ERROR FUNCTION, RESIGNAL STATEMENT, OR SIGNAL STATEMENT
Explanation
The SQLSTATE specified in the RAISE_ERROR function, RESIGNAL statement, or SIGNAL statement of a trigger or a routine does not conform to the rules for a valid SQLSTATE.
System action
The statement cannot be processed.
Programmer response
Change the SQLSTATE specified in the RAISE_ERROR function, RESIGNAL statement, or SIGNAL statement so that it conforms to the rules of the statement.
For the RAISE_ERROR function,
the SQLSTATE must be a character string containing exactly five (5)
characters. It must be of type CHAR defined with a length of five
(5), or, a type VARCHAR defined with a length of five (5) or greater.
The SQLSTATE value must conform to the following rules:
- Each character must be from the set of digits ('0' through '9') or non-accented upper case letters ('A' through 'Z').
- The SQLSTATE class (the first two characters) cannot be '00', '01' or '02' because these characters do not indicate error classes.
- If the SQLSTATE class (the first two characters) start with the character '0' through '6' or 'A' through 'H', then the subclass (the last three characters) must start with a letter in the range 'I' through 'Z'.
- If the SQLSTATE class (the first two characters) start with the character '7', '8', '9' or 'I' through 'Z', then the subclass (the last three characters) must be from the set of characters '0' through '9' or 'A' through 'Z'.
For the RESIGNAL and SIGNAL statements, the SQLSTATE
value must be exactly five (5) characters that follow the following
rules:
- Each character must be from the set of digits '0' through '9' or non-accented upper case letter 'A' through 'Z'.
- The SQLSTATE class (the first two characters) cannot be '00' because it represents successful completion.
SQLSTATE
428B3