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.
