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@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 - 02:43:43 CST