Oracle Error PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

Oracle Error Message

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

Reason for the Error

In a TABLE type definition, a nested record type was specified as the element type. This is not allowed. All fields in the record must be scalars.

Solution

Remove the TABLE type definition, or replace the nested record type with a simple record type.