create or replace procedure cnav_name_for_group_id
(
 p_group_name OUT varchar2,
 p_group_id IN number 
)
IS
cursor c_getname is 
    select group_name
      from grouping
      where group_id=p_group_id;
BEGIN
 if (p_group_id is null) then
   p_group_name := null;
   return;
 end if;
 open c_getname;
 fetch c_getname into p_group_name;
 close c_getname;
END cnav_name_for_group_id;
/
show errors;