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

EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

1 Answers  


ORA-26717: SCN limit reached

1 Answers  


RMAN-12015: configuration for string channel number is ignored

1 Answers  


ORA-25470: duplicate attribute value for variable: string

1 Answers  


ORA-22956: The set contains no elements

1 Answers  






ORA-13008: the specified date format has an invalid component

1 Answers  


QSM-02030: reduced precision specified for prebuilt mv

1 Answers  


ORA-25144: invalid option for CREATE TABLESPACE with TEMPORARY contents

1 Answers  


ORA-30083: syntax error was found in interval value expression

1 Answers  


PCC-00115: Array required here

1 Answers  


ORA-02739: osncon: host alias is too long

1 Answers  


ORA-02055: distributed update operation failed; rollback required

1 Answers  


Categories