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