Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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
columns to fill all of the fields in the record.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers  


IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$

1 Answers  


RMAN-06005: connected to target database: string (DBID=string)

1 Answers  


ORA-07703: error in archive text: need '/' after device type

1 Answers  


ORA-30340: illegal dimension name

1 Answers  






ORA-13781: The tuning task does not exist.

1 Answers  


SQL-02152: Invalid numeric variable for use in an array GET/SET statement

1 Answers  


RMAN-08040: full resync skipped, controlfile is not current or backup

1 Answers  


ORA-10588: Can only allow 1 corruption for normal media/standby recovery

1 Answers  


NID-00397: Changing database name from string to string

1 Answers  


ORA-17624: Failed to delete directory string

1 Answers  


SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables

1 Answers  






Categories