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-30566: Index maintainence clause not allowed for this command

1 Answers  


EXP-00047: Missing tablespace name(s)

1 Answers  


ORA-01629: max # extents (string) reached saving undo for tablespace string

1 Answers  


ORA-24120: invalid string parameter passed to DBMS_REPAIR.string procedure

1 Answers  


QSM-02102: mv FROM list references an object in the SYS schema

1 Answers  


DGM-16912: Unknown command "string". Try "help"

1 Answers  


ORA-23318: a ddl failure has occurred

1 Answers  


ORA-33214: (CINSERT02) The workspace object dimension is too large.

1 Answers  


NID-00416: Change of database name failed.

1 Answers  


DRG-11439: index name length exceeds maximum of string bytes

1 Answers  


ORA-24010: QUEUE string does not exist

1 Answers  


TNS-04045: Invalid specification of time

1 Answers  


Categories