Problem is that you declare a variable of type nested table but do not initialise it.
In any case for sparse collections you would want to use associative array, not nested table. Change declaration of "T_DEP_RECORD" to...
Code:TYPE t_dept_record IS TABLE OF departments%ROWTYPE INDEX BY BINARY_INTEGER;




Reply With Quote