Oracle Solution for Error ora-02348

ORA-02348: cannot create VARRAY column with embedded LOB

What triggered the Error:

An attempt was made to create a column of a VARRAY type which has an embedded LOB attribute. The LOB could be an attribute of a subtype of the declared type of VARRAY's element.

What should we do to fix it:

Remove offending attribute from type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.