ORA-06531: Reference to uninitialized collection
Hi,
I want to check a condition in a nested table and if a record in that table satisfies a condition, i need to copy that record to another nested table. i have the below procedure.
When i try to compile it, it compiles fine. But i get a runtime exception saying "ORA-06531: Reference to uninitialized collection". I know its coming from this statement
" x_notes_rec(counter1) := x_notes_one_rec(counter);".
What is the problem? How to solve this?
PROCEDURE get_tasklist (
p_assignee_id IN NUMBER
,x_notes_rec OUT xx_fs_mob_loc_rec.task_notes_tab
I want to check a condition in a nested table and if a record in that table satisfies a condition, i need to copy that record to another nested table. i have the below procedure.
When i try to compile it, it compiles fine. But i get a runtime exception saying "ORA-06531: Reference to uninitialized collection". I know its coming from this statement
" x_notes_rec(counter1) := x_notes_one_rec(counter);".
What is the problem? How to solve this?
PROCEDURE get_tasklist (
p_assignee_id IN NUMBER
,x_notes_rec OUT xx_fs_mob_loc_rec.task_notes_tab
0