ORA-02348: cannot create VARRAY column with embedded LOB

ORA-02348: cannot create VARRAY column with embedded LOB


Cause:


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.



Action:


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