CREATE FUNCTION GETROWSUM () return number IS l_tmp NUMBER; BEGIN SELECT SUM(i) INTO l_tmp FROM test; return l_tmp; Exception When no_data_found then return -99; END GETROWSUM; /