Re: Need help with PL/SQL's bulk collect.
From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 19 Mar 2002 00:43:43 -0800
Message-ID: <dee17a9f.0203190043.1f88945c_at_posting.google.com>
Date: 19 Mar 2002 00:43:43 -0800
Message-ID: <dee17a9f.0203190043.1f88945c_at_posting.google.com>
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 - 09:43:43 CET