Quick Search:
 
 Oracle Database Error: PLS-00497      [Return To Oracle Error Index] Jump to:  
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 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2025 psoug.org