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-30393: a query block in the statement did not rewrite

1 Answers  


ORA-02054: transaction string in-doubt

1 Answers  


RMAN-02006: script line too long

1 Answers  


LPX-00269: all three access functions (open/close/read) must be provided

1 Answers  


TNS-00307: Navigator: Reread parameter data

1 Answers  






RMAN-06540: tablespace string will be excluded from future whole database backups

1 Answers  


ORA-22896: cannot have both scope and referential constraint on REF column "string"

1 Answers  


ORA-19506: failed to create sequential file, name="string", parms="string"

1 Answers  


QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string

1 Answers  


NNL-00803: Queries received, type ALIAS: number

1 Answers  


TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file

1 Answers  


ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

1 Answers  


Categories