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


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



PLS-00495: too many 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
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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-10633: No space found in the segment

1 Answers  


ORA-13911: Threshold not found

1 Answers  


ORA-16234: restarting to reset Logical Standby apply

1 Answers  


RMAN-06474: maintenance channels are not allocated

1 Answers  


TNS-12690: Server Authentication failed, login cancelled

1 Answers  






AMD-00125: dimension #string: analytic workspace column level dimension not specified

1 Answers  


NZE-29049: Unknown record

1 Answers  


QSM-02070: PCT not supported with this type of partitioning

1 Answers  


ORA-12152: TNS:unable to send break message

1 Answers  


ORA-06744: TLI Driver: listener cannot bind

1 Answers  


LPX-00609: Function call with invalid number of arguments in '~1S'.

1 Answers  


ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers  






Categories