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

IMG-00554: extra value in rotate operation

1 Answers  


ORA-14061: data type or length of an index partitioning column may not be changed

1 Answers  


ORA-02184: resource quotas are not allowed in REVOKE

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  






ORA-16775: Target standby in switchover operation has missing redo logs.

1 Answers  


ORA-29325: SET COMPATIBILITY release number lower than string

1 Answers  


ORA-37102: (XSVPART02) Invalid partition name string.

1 Answers  


LSX-00148: annotation must come first in "~S"

1 Answers  


ORA-06422: NETCMN: Error in sending data

1 Answers  


IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.

1 Answers  


PLS-00255: CALL Specification parameters cannot have default values

1 Answers  


Categories