ACS3 Data Model

     1: function user_group_name_from_id (v_group_id IN integer)
     2: return varchar
     3: IS
     4:   v_group_name    user_groups.group_name%TYPE;
     5: BEGIN
     6:   if v_group_id is null
     7:      then return '';
     8:   end if;
     9: 
    10:   select group_name into v_group_name from user_groups where group_id = v_group_id;
    11:   return v_group_name;
    12: END;