How to fix the Oracle error PLS-00511: a record may not contain a PL/SQL table of records?

In this post, you’ll learn more about the Oracle ErrorPLS-00511: a record may not contain a PL/SQL table of records with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00511: a record may not contain a PL/SQL table of records

Reason for the Error PLS-00511: a record may not contain a PL/SQL table of records

n a RECORD definition, one of the fields was declared as a PL/SQL table of records. This is not allowed. A record can be the component of another record (that is, records can be nested), but a PL/SQL table of records cannot be the component of a record.

How to fix the Error PLS-00511: a record may not contain a PL/SQL table of records ?

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

Remove the field declaration, or revise it to specify a simple record type.