Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help with PL/SQL's bulk collect.
Duncan
You have declared a nested table type and not initialised it.
Either initialise the nested table:-
TYPE EmpnoTab IS TABLE OF emp.empno%TYPE; emp_nos EmpnoTab := EmpnoTab();
Or use an index-by table instead...
TYPE EmpnoTab IS TABLE OF emp.empno%TYPE
INDEX BY BINARY_INTEGER;
emp_nos EmpnoTab;
I prefer to use index-by tables as they are "self-maintaining". I only use nested tables when I need access to the PL/SQL table from SQL.
Regards
Adrian Received on Tue Mar 19 2002 - 02:43:43 CST