How to fix the Oracle error PLS-00495: too many columns in SELECT…INTO statement after bursting record targets?

In this post, you’ll learn more about the Oracle ErrorPLS-00495: too many columns in SELECT…INTO statement after bursting record targets with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00495: too many columns in SELECT…INTO statement after bursting record targets

Reason for the Error PLS-00495: too many columns in SELECT…INTO statement after bursting record targets

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 fields in the record for each of the columns.

How to fix the Error PLS-00495: too many columns in SELECT…INTO statement after bursting record targets ?

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

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