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

NZE-28791: certificate verification failure

1 Answers  


ORA-06317: IPA: Local maximum number of users exceeded

1 Answers  


ORA-24780: cannot recover a transaction while in an existing transaction

1 Answers  


ORA-06003: NETASY: port write failure

1 Answers  


SQL-02103: Inconsistent cursor cache. Out of range cursor cache reference

1 Answers  






ORA-14081: new partition name must differ from the old partition name

1 Answers  


DRG-11857: Server Timed Out

1 Answers  


AMD-00126: dimension #string: analytic workspace column level relation not specified

1 Answers  


ORA-25104: UNRECOVERABLE option can only be used with ALTER INDEX REBUILD

1 Answers  


PCB-00320: VARYING host variable "string" is an Oracle extension

1 Answers  


IMG-00550: invalid scanlineOrder specified

1 Answers  


ORA-02080: database link is in use

1 Answers  


Categories