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

NNC-00401: program interface initialization failed

1 Answers  


ORA-10906: Unable to extend segment after insert direct load

1 Answers  


ORA-06606: LU6.2 Driver: Unexpected response from SNA

1 Answers  


ORA-27475: "string.string" must be a string

1 Answers  


QSM-01029: materialized view, string, is stale in ENFORCED integrity mode

1 Answers  


DRG-51300: error getting dml Queue lock

1 Answers  


ORA-06958: Failed to access configuration file

1 Answers  


LPX-00267: could not resolve relative URL ~s

1 Answers  


ORA-01263: Name given for file destination directory is invalid

2 Answers  


CLSS-02203: unable to access voting device: string

1 Answers  


ORA-19617: file string contains different resetlogs data

1 Answers  


ORA-30504: system triggers cannot have a FOR EACH ROW clause

1 Answers  


Categories