Oracle Solution for Error ora-22859

ORA-22859: invalid modification of columns

What triggered the Error:

attempt was made to modify an object, REF, VARRAY, nested table, or LOB column type.

What should we do to fix it:

eate a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.