Oracle Error PLS-00393: wrong number of columns in SELECT…INTO statement

Oracle Error Message

PLS-00393: wrong number of columns in SELECT…INTO statement

Reason for the Error

The number of columns selected by a SELECT…INTO statement does not match the number of variables in the INTO clause.

Solution

Change the number of columns in the select list or the number of variables in the INTO clause so that the numbers match.