Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t(Id INT, Val INT);
INSERT INTO t(Id, Val)
SELECT 10, 1 FROM dual
UNION ALL SELECT 20,2 FROM dual
UNION ALL SELECT 30, 1 FROM dual
UNION ALL SELECT 40,2 FROM dual
4 rows affected

SELECT * FROM t;


ID
VAL


10
1

20
2

30
1

40
2


DECLARE
   l_cnt INT;
BEGIN
   DELETE FROM t RETURNING SUM(val) INTO l_cnt;
   DBMS_OUTPUT.put_line('l_cnt: ' || l_cnt);
END;
//
1 rows affected

dbms_output:
l_cnt: 6

INSERT INTO t(Id, Val)
SELECT 10, 1 FROM dual
UNION ALL SELECT 20,2 FROM dual
UNION ALL SELECT 30, 1 FROM dual
UNION ALL SELECT 40,2 FROM dual
4 rows affected

DECLARE
   l_cnt INT;
BEGIN
   DELETE FROM t RETURNING SUM(DISTINCT val) INTO l_cnt;
   DBMS_OUTPUT.put_line('l_cnt: ' || l_cnt);
END;
//
ORA-00934: group function is not allowed here
ORA-06512: at line 4