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

Question Posted / guest

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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?

6 Yes

1 No

More Oracle Errors Interview Questions

PCC-00100: Non integer label is not ANSI

ORA-02234: changes to this table are already logged

RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

PLS-00461: mismatch REPEATABLE information between specification and body of 'string'

QSM-00762: the specified Summary Advisor workload string does not exist

ORA-32505: too many watchpoints

ORA-01135: file string accessed for DML/query is offline

ORA-31207: DBMS_LDAP: PL/SQL - Invalid LDAP search time value.

ORA-22053: overflow error

NNL-00835: Average delete processing time: string

ORA-00077: dump string is not valid

ORA-02831: Segment deallocation failed - empty segment list

For more Oracle Errors Interview Questions Click Here