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

PLS-00497: cannot 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. type with the corresponding column.

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

No comments:

Post a Comment