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

TNS-04018: Instance already started

PCB-00575: PLS-number: string

ORA-03299: cannot create dictionary table string

LPX-00301: error in XPATH evaluation

PCC-00045: %s clause inappropriate at line number in file string. Ignored.

PLS-00597: expression 'string' in the INTO list is of wrong type

ORA-13402: the rasterType is null or not supported

NZE-29110: Invalid PKCS #12 bag type

ORA-24031: invalid value, string should be non-NULL

RMAN-08162: executing Memory Script

ORA-33070: (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.

TNS-00259: Disabled Interchange list:

For more Oracle Errors Interview Questions Click Here