Oracle Solution for Error ora-39801

Solution for Oracle Error ORA-39801

ORA-39801: Subtype "string

"."string

" is not a valid subtype for column string

.

What triggered the Error:

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

What should we do to fix it:

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