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-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.

1 Answers  


ORA-08466: raw buffer length string is too short for string

1 Answers  


RMAN-06161: error when inspecting auxiliary filename: string

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


ORA-24328: illegal attribute value

1 Answers  


QSM-00765: cannot validate user-defined workload because table string.string is invalid.

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


ORA-24431: Statement does not exist in the cache

1 Answers  


ORA-01267: Failure getting date/time

1 Answers  


DRG-50863: string assignment failed

1 Answers  


ORA-02057: 2PC: string: bad two-phase recovery state number string from string

1 Answers  


RMAN-03019: asynchronous RPCs are NOT working

1 Answers  


Categories