-782   A CONDITION OR SQLSTATE condition-value SPECIFIED IS NOT VALID

Explanation

An SQL routine specified a condition value that is not valid.

condition-value
Either a specific condition value, which is provided as an SQLSTATE value, or a general condition value, such as SQLEXCEPTION, SQLWARNING, or NOT FOUND.

The condition or SQLSTATE value is not valid for one of the following reasons:

  • The handler declaration or condition declaration specifies an SQLSTATE value that is not valid.
  • The condition or SQLSTATE value has already been specified by another handler in the same scope.
  • The condition or SQLSTATE was specified in the same handler as SQLEXCEPTION, SQLWARNING, or NOT FOUND.

System action

The statement cannot be processed.

User response

Correct the condition or SQLSTATE value.

SQLSTATE

428D7