-789 THE DATA TYPE OR OTHER ATTRIBUTES FOR PARAMETER OR SQL VARIABLE name ARE NOT SUPPORTED IN THE ROUTINE

Explanation

This error is issued for the following situations:

  • A default value cannot be specified for a parameter of type ARRAY. Only DEFAULT NULL can be explicitly specified if array-type-name is specified.
  • A table parameter (TABLE LIKE) cannot be specified when adding or replacing a version of an existing procedure with a CREATE OR REPLACE statement.
name
The name of the parameter or SQL variable.

System action

The statement cannot be processed.

Programmer response

Do not specify a default value for a parameter of type ARRAY.

Do not specify a table parameter.

SQLSTATE

429BB