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.