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-08278: Cannot get CPU statistics

1 Answers  


PLS-00323: subprogram or cursor 'string' is declared in a package specification and must be defined in the package body

1 Answers  


ORA-16034: FROM parameter is incompatible with MANAGED recovery

1 Answers  


ORA-02060: select for update specified a join of distributed tables

1 Answers  


ORA-06308: IPA: No more connections available

1 Answers  






ORA-02757: osnfop: fork_and_bind failed

1 Answers  


CLSS-00003: unable to determine cluster name. type string

1 Answers  


CLSR-01002: Unable to process instance startup

2 Answers  


CLSR-00002: Oracle error encountered while executing string

1 Answers  


ORA-30511: invalid DDL operation in system triggers

1 Answers  


ORA-02782: Both read and write functions were not specified

1 Answers  


ORA-29362: plan directive string, string does not exist

1 Answers  


Categories