Oracle DB Error ORA-02348 cannot create VARRAY column with embedded LOB

The following is the cause of this 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.

Action you can take to resolve this issue: Remove the offending attribute from the type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related