ORA-02348: cannot create VARRAY column with embedded LOB



ORA-02348: cannot create VARRAY column with embedded LOB..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.

1 Answers  


ORA-00114: missing value for system parameter SERVICE_NAMES

1 Answers  


PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 Answers  


ORA-30733: cannot specify rowid constraint on scoped ref column

1 Answers  


ORA-13225: specified index table name is too long for a spatial index

1 Answers  






ORA-16530: invalid buffer or length

1 Answers  


NNC-00422: invalid data type name "string"

1 Answers  


RMAN-06205: Uncataloged string objects

1 Answers  


PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

1 Answers  


ORA-23432: master site string already exists

1 Answers  


ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 Answers  


ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers  


Categories