ACS3 Data Model

     1: function group_names_of_user (
     2: 	v_user_id IN Integer) Return varchar2 IS
     3: 	   counter integer;
     4: 	   return_string 	varchar(2000);
     5: 	CURSOR c_user_groups is
     6: 		select group_name
     7: 		from user_groups, user_group_map
     8: 		where user_groups.group_id = user_group_map.group_id
     9: 		and user_group_map.user_id = v_user_id;
    10: BEGIN
    11: 	counter := 0;
    12: 	for v_group_data in c_user_groups LOOP
    13: 		counter := counter + 1;
    14: 		if counter = 1 then
    15: 			return_string := v_group_data.group_name;
    16: 		else
    17: 			return_string := return_string || ', ' || v_group_data.group_name;
    18: 		end if;
    19: 	End Loop;
    20: 	Return return_string;
    21: END;