Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

PLS-00495

too many columns in SELECT...INTO statement after bursting record targets

Cause

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.


Action

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