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-08315: sllfrb: Error reading file

NPL-00307: ASN.1 sequence has already been ended on write

TNS-12688: Login failed: the SecurID server rejected the new pincode

ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

DRG-51200: open keymap failed for index id = string

TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

LPX-00605: Invalid attribute '~1S' in element '~2S'.

ORA-09858: sfngat: the input file name is not in the OMF format

TNS-01093: %s * string * number

ORA-15150: instance lock mode 'string' conflicts with other ASM instance(s)

ORA-02229: invalid SIZE option value

For more Oracle Errors Interview Questions Click Here