How to fix the Oracle error PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB?

In this post, you’ll learn more about the Oracle ErrorPLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB ?

You can fix this error in Oracle by following the below steps

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