Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00535: A VARRAY type may not contain a NESTED TABLE,
VARRAY or LOB



PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB..

Answer / guest

Cause: An attempt was made to do one of the following:
define a VARRAY type containing a nested collection type or
LOB or define a VARRAY type of an object type that has a
nested attribute which is one of NESTED TABLE, VARRAY or LOB
type.

Action: Check the VARRAY definitions to be sure that they do
not contain nested colection types, LOBs or nested attributes.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers  


ORA-19710: unsupported character set string

1 Answers  


ORA-00155: cannot perform work outside of global transaction

1 Answers  


RMAN-08109: channel string: restored block(s) from backup piece string

1 Answers  






NZE-29049: Unknown record

1 Answers  


ORA-01120: cannot remove online database file string

1 Answers  


QSM-02131: agg(expr) requires correspondng SUM(expr) function

1 Answers  


RMAN-06167: already connected

1 Answers  


ORA-09710: soarcv: buffer overflow.

1 Answers  


DRG-11611: URL store: unknown protocol specified in string

1 Answers  


PLS-00128: Illegal number of arguments for pragma string

1 Answers  






Categories