Oracle Error ORA-39801: Subtype “string”.”string” is not a valid subtype for column string.

Oracle Error Message

ORA-39801: Subtype “string”.”string” is not a valid subtype for column string.

Reason for the Error

Subtype specified was not the declared type nor was it derived from the declared type.

Solution

Ensure all subtypes specified are either the declared type or derived from the declared type.