Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-01190: The user is not authorized to execute the requested listener command

1 Answers  


NNL-00230: Controller NOCONFIRM mode is currently string

1 Answers  


NID-00107: File I/O error on datafile "string" during string operation (number/string)

1 Answers  


ORA-12899: value too large for column string (actual: string, maximum: string)

1 Answers  


PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 Answers  






PCC-01101: Your Pro*FORTRAN authorization is about to expire

1 Answers  


RMAN-06730: no channel to restore a backup of the SPFILE

1 Answers  


ORA-01986: OPTIMIZER_GOAL is obsolete

1 Answers  


NZE-29153: RSA self-test failure

1 Answers  


ORA-07210: slcpu: getrusage error, unable to get cpu time.

1 Answers  


NNO-00635: warning: ignoring duplicate forwarder "string"

1 Answers  


EXP-00026: conflicting modes specified

4 Answers  






Categories