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

SQL*Loader-00511: Unable to initialize read functions

1 Answers  


ORA-25963: join index must be created on tables

1 Answers  


DRG-51200: open keymap failed for index id = string

1 Answers  


RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

1 Answers  


ORA-19501: read error on file "string", blockno string (blocksize=string)

1 Answers  






TNS-00524: Current operation is still in progress

1 Answers  


ORA-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


PLS-00594: the SELF parameter can be declared only as IN or as IN OUT

2 Answers  


ORA-02815: Unable to attach shared memory

1 Answers  


QSM-02007: multiple instances of the same table or view

1 Answers  


ORA-31601: Function string cannot be called now that fetch has begun.

1 Answers  


ORA-06703: TLI Driver: send break message failed

1 Answers  


Categories