CREATE OR REPLACE FUNCTION getproject
    RETURN SYS_REFCURSOR
AS
    project SYS_REFCURSOR;

BEGIN
    OPEN project
    FOR SELECT * FROM project;
    RETURN project;

END getproject;