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-07232: slemcc: fclose error.

1 Answers  


ORA-13275: spatial index creation failure on unsupported type

1 Answers  


ORA-13365: layer SRID does not match geometry SRID

1 Answers  


ORA-30734: cannot specify scope constraint on ref column with rowid

1 Answers  


ORA-02436: date or system variable wrongly specified in CHECK constraint

1 Answers  






PLS-00354: username must be a simple identifier

1 Answers  


ORA-30437: all job queue processes have stopped running

1 Answers  


QSM-02045: START WITH clause in mv

1 Answers  


ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

1 Answers  


ORA-16230: committing transaction string string string

1 Answers  


NZE-28764: failure to retrieve a configuration parameter

1 Answers  


ORA-27211: Failed to load Media Management Library

1 Answers  


Categories