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-24754: cannot start new transaction with an active transaction

1 Answers  


ORA-16035: missing required keyword string

1 Answers  


ORA-24393: invalid mode for creating connection pool

1 Answers  


PLS-00735: Attempted to declare more than one formal ellipsis parameter

1 Answers  


TNS-12635: No authentication adapters available

1 Answers  


NNO-00705: warning: cannot open checkpoint file "string", checkpointing disabled

1 Answers  


ORA-06540: PL/SQL: compilation error

1 Answers  


ORA-15177: cannot operate on system aliases

1 Answers  


ORA-09967: scumnt: unable to create or open file

1 Answers  


ORA-13622: The recommendation annotation string is invalid.

1 Answers  


TNS-12645: Parameter does not exist.

1 Answers  


NNL-00266: Round trip time is string

1 Answers  


Categories