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-00130: invalid listener address 'string'

2 Answers  


PCC-02105: Unable to open list file

1 Answers  


ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.

1 Answers  


NNO-00622: warning: too many auto-refresh failures for name "string", query expired

1 Answers  


QSM-01087: query grouping on a column that cannot be derived from materialized view, string

1 Answers  






ORA-13515: Error encountered during Database Usage Statistics capture

1 Answers  


RMAN-06457: UNTIL scn (string) is ahead of last scn in archived logs (string)

1 Answers  


ORA-09272: remote os logon is not allowed

1 Answers  


ORA-13484: the file format and/or compression type is not supported

1 Answers  


RMAN-20011: target database incarnation is not current in recovery catalog

1 Answers  


ORA-29846: cannot create a local domain index on a string partitioned table

1 Answers  


RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command

1 Answers  


Categories