Message Oracle SQL-02112 - SELECT..INTO returns too many rows

ERRORSELECT..INTO returns too many rows
CAUSEA SELECT...INTO statement returned more rows than can be stored in the host variable provided.
ACTIONThere are 3 possible solutions: