Message Oracle PLS-00497 - cannot mix between single row and multi-row (BULK) in INTO list

ERRORcannot mix between single row and multi-row (BULK) in INTO list
CAUSE- When BULK syntax (e.g. BULK COLLECT INTO) is used to retrieve data, every variable in the INTO list has to be of type that is a collection of the type of the corresponding column. - When BULK is NOT used, every variable in the INTO list has to be of compatible type with the corresponding column.
ACTIONChange the INTO list so that all variables have correct data types