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

TNS-12683: encryption/crypto-checksumming: no Diffie-Hellman seed

1 Answers  


ORA-19765: mount id string does not match mount id string in control file

1 Answers  


UDI-00011: parameter string is incompatible with parameter string

1 Answers  


NNL-00251: DEFAULT-FORWARDER-ONLY mode is now enabled

1 Answers  


PLS-00516: Type mismatch between object table and value 'string' in INSERT statement.

1 Answers  






ORA-26048: Scoped REF column has wrong table name.

1 Answers  


CLSR-06502: Failed to connect to database

1 Answers  


ORA-24090: at least one protocol must be enabled

1 Answers  


NNL-00231: Controller NOCONFIRM mode is now string

1 Answers  


DRG-11839: Internal Server Error

1 Answers  


RMAN-06013: duplicate channel identifier found: string

1 Answers  


ORA-04093: references to columns of type LONG are not allowed in triggers

1 Answers  


Categories