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_at_lucent.com>
Hi,
ERROR at line 5:
, from into
The symbol "," was substituted for "COLLECT" to continue.
Date: Mon, 18 Mar 2002 16:31:19 +0000
Message-ID: <3C961657.DA3B021_at_lucent.com>
Hi,
[Quoted] 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 - 17:31:19 CET