Anonymous

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;
/