Oracle Error PLS-00496: too few columns in SELECT…INTO statement after bursting record targets

Oracle Error Message

PLS-00496: too few columns in SELECT…INTO statement after bursting record targets

Reason for the Error

Type checking indicated the columns in a SELECT or FETCH were being collected into a record in the INTO list. The record was burst into its fields. There were not enough columns to fill all of the fields in the record.

Solution

Change the number of columns or the record variable(s) in the INTO clause so that they match.