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

Cause: One of the following: When BULK syntax (for example, 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.

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/