SQL & PL/SQL

Hi,

I want to get the record set into array in the procedure and do the processing of the array later in procedure.

below is the stored procedure i am working on:

procedure bulk_delete_group(p_group_id in Array_GroupListID) as
begin

for i in p_group_id.first..p_group_id.last loop

--Here I have to get the list of user id before deleting group
SELECT user_id into *<SOME ARRAY>* FROM group_members WHERE group_id = p_group_id(i);

DELETE group WHERE group_id = p_group_id(i);

--Process the user id array after group deletion..
end loop;
end bulk_delete_group;

Thanks in advance
Aditya