Oracle Error: PLS-00497
Error Description:
Cannot mix between single row and multi-row (BULK) in INTO list
Error 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.
There haven't been any comments added for this error yet. You may add one if you like.
Add a comment
|
|