Bulk collect in PL/SQL [message #38719] |
Wed, 08 May 2002 07:40 |
Jason Wiest
Messages: 3 Registered: May 2002
|
Junior Member |
|
|
I'm trying to perform a bulk collect with dynamic SQL.
If I use a static cursor, I do not have any problems, but when I do dynamic, I do. The error is "Invalid cursor" on the fecth statement
Here is my code.
declare
strSQL VARCHAR2(1000);
TYPE CHAR_ARRAY IS VARRAY(10000) OF VARCHAR2(500);
EmployeeName CHAR_ARRAY := CHAR_ARRAY();
begin
strSQL := 'SELECT NAME
FROM EMPLOYEE';
OPEN crsr FOR strSQL;
FETCH crsr BULK COLLECT INTO EmployeeName;
CLOSE crsr;
|
|
|
|