Oracle Solution for Error ora-22858

ORA-22858: invalid alteration of datatype

What triggered the Error:

attempt was made to modify the column type to object, REF, nested table, VARRAY or LOB 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.