Unnamed

CREATE OR REPLACE FUNCTION GetHours( description IN VARCHAR2 )    RETURN INT IS    hours INT;    BEGIN        //dbms_output.put_line('Searching for ' || description);        select SUM(f.stunden) into hours        from FAECHER f        join FACHBEREICH fb on f.FACHBEREICH_ID = fb.FACHBEREICH_ID         join STUDIENGANGSLEITER s on fb.PERSONEN_ID = s.PERSONEN_ID        where fb.KURZBEZEICHNUNG = description;        IF hours IS NULL THEN            hours := 0;        END IF;        //dbms_output.put_line('Return value ' || hours);                return hours;    END;