Need help with PL/SQL's bulk collect.

From: Duncan Rance <drance_at_lucent.com>
Date: Mon, 18 Mar 2002 16:31:19 +0000
Message-ID: <3C961657.DA3B021@lucent.com>

Hi,

I need help with using bulk collect in PL/SQL. The code I'm using is:

DECLARE
    TYPE EmpnoTab IS TABLE OF emp.empno%TYPE;     emp_nos EmpnoTab;
BEGIN
    SELECT empno BULK COLLECT INTO emp_nos       FROM emp;
END; But I get:

    SELECT empno BULK COLLECT INTO emp_nos

                      *

ERROR at line 5:

ORA-06550: line 5, column 23:
PLS-00103: Encountered the symbol "COLLECT" when expecting one of the
following:

, from into
The symbol "," was substituted for "COLLECT" to continue.

I can't see why this shouldn't work. Any ideas anyone?

Thanks in advance,
Duncan Received on Mon Mar 18 2002 - 10:31:19 CST