-20436 THE DATA TYPE SPECIFIED FOR AN ARRAY TYPE IS NOT VALID.

Explanation

The data type that is specified for an array in one of the following contexts is not valid:

  • CREATE TYPE statement
  • Array constructor
  • Argument to UNNEST
  • Argument to ARRAY_AGG
  • Target of ARRAY_AGG

The following restrictions apply to the data type for an array:

  • These data types are not supported:
    • ROWID
    • XML
    • A user-defined data type other than an array data type
  • The data type for an array index of an associative array must be INTEGER or VARCHAR, with a length attribute no greater than 32704.

System action

The statement cannot be processed.

Programmer response

Use a supported data type.

SQLSTATE

429C2