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

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