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

ORA-01595: error freeing extent (string) of rollback segment (string))

TNS-12696: Double Encryption Turned On, login disallowed

PLS-00506: User Defined Constrained Subtypes are disallowed

PCC-02443: This usage is only valid when DYNAMIC=ANSI is specified

EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported

PCB-00633: Invalid host variable and attribute pairing

PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year.

DGM-16934: You must start instance "string" manually.

ORA-31019: Recursive deletion snapshot too old for string/string

ORA-06102: NETTCP: cannot allocate context area

TNS-01171: Event detection broke for dispatcher: string

For more Oracle Errors Interview Questions Click Here