PLS-00393: wrong number of columns in SELECT...INTO statement



PLS-00393: wrong number of columns in SELECT...INTO statement..

Answer / guest

Cause: The number of columns selected by a SELECT...INTO
statement does not match the number of variables in the INTO
clause.

Action: Change the number of columns in the select list or
the number of variables in the INTO clause so that the
numbers match.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32106: array fetch not allowed without setBuffer on all columns

1 Answers   Oracle,


ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

1 Answers  


ORA-02790: File name is too long

1 Answers  


TNS-00031: INTCTL: internal NT error

1 Answers  


ORA-02237: invalid file size

1 Answers  






ORA-13862: Statistics aggregation for client identifier string is not enabled

1 Answers  


ORA-31635: unable to establish job resource synchronization

1 Answers  


SQL*Loader-00464: file offset for beginning of lob is string

1 Answers  


ORA-00038: Cannot create session: server group belongs to another user

1 Answers  


ORA-06035: NETDNT: connect failed, insufficient resources

1 Answers  


ORA-19615: some files not found in backup set

1 Answers  


ORA-26060: Can not convert type identifier for column string

1 Answers  


Categories