oracle FUNCTION
CREATE OR REPLACE FUNCTION get_cop_project_owners(p_project_id NUMBER)
RETURN VARCHAR2 IS
l_owers VARCHAR2(500);
CURSOR cur_owner IS
SELECT ppf.full_name
FROM per_people_f ppf, cop_project_coowner cpc
WHERE 1 = 1
AND trunc(SYSDATE) BETWEEN ppf.effective_start_date AND
ppf.effective_end_date
AND ppf.person_id = cpc.coowner_person_id
AND cpc.project_id = p_project_id;
BEGIN
FOR rec IN cur_owner LOOP
l_owers := l_owers || rec.full_name;
END LOOP;
RETURN l_owers;
EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END;