Oracle Error ORA-39797: The subtype index value is not valid.

Oracle Error Message

ORA-39797: The subtype index value is not valid.

Reason for the Error

The subtype index value in the column array was not valid for the object column or object table.

Solution

Set a valid subtype index value in the column array for this table or column.