Oracle Error Message
PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list
Reason for the Error
– 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.
Solution
Change the INTO list so that all variables have correct data types