How to fix the Oracle error PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list?

In this post, you’ll learn more about the Oracle ErrorPLS-00497: cannot mix between single row and multi-row (BULK) in INTO list with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

– 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.

How to fix the Error PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list ?

You can fix this error in Oracle by following the below steps

Change the INTO list so that all variables have correct data types