I have a script executed in SQL*PLUS command line that should give out the summ of all real updated rows from the WHERE clause after all update executes simiilar as on execute update command directely in SQL*Plus with "1 row updated".

But the following code is not returning to the SQL> prompt.
How do I get the sum of the real updates rows in the WHERE clause printed in the spool output ?

--Variblensubst
--@ W:\SG-323\TeamZentraleKatalogredaktion\Bankleitzahlen\ZZZTest-ZZB\2017-Q1\ZD_ZZB-update-nicht-historisch-Merker-M-2017-Q1.sql
set define off;

set COLSEP '|'
set verify off
set feedback off
set trimspool on
set trimout on
--output welche SQL statements
set echo on
--Variable zum Zählen der Zeilen
DECLARE @rowsreturned INT
SET @rowsreturned = @@ROWCOUNT


spool W:\SG-323\TeamZentraleKatalogredaktion\Bankleitzahlen\ZZZTest-ZZB\2017-Q1\sätze-zum-modifizieren-nicht-historisch-2017-Q1.txt


--update nicht historische Sätze

update ZD_ZZB set ZZBV='010',ZZBPLZ='30890', ZZBBTEXZ='Commerzbank Barsinghausen ', ZZBPAN='24250', ZZBNBLZ='00000000' where ZZBS = '056053' and ZZBDATB='20991231';
update ZD_ZZB set ZZBV='010',ZZBPLZ='49406', ZZBBTEXZ='VB Diepholz-Barnstorf ', ZZBPAN='62386', ZZBNBLZ='00000000' where ZZBS = '025945' and ZZBDATB='20991231';
........


--select zum Zählen der Zeilen
SELECT rowsreturned

--Einstellungen für spool zurücknehmen
spool off

set verify on
set feedback on

SQL> spool /tmp/output.log
SQL> drop table t purge;

Table dropped.

SQL> create table t as select * from dba_objects;

Table created.

SQL> update t set object_id = object_id+1 where owner = 'SYS';

42753 rows updated.

SQL> commit;

Commit complete.

SQL> update t set object_id = object_id+1 where owner = 'SCOTT';

17 rows updated.

SQL> commit;

Commit complete.

SQL> spool off

grep "rows updated" output.log | gawk "{s+=$1}END{print s}"
42770
<code>

2) Use PL/SQL as a wrapper

<code>
declare
  tot int := 0;
begin
update ZD_ZZB set ...; 
tot := tot + sql%rowcount;

update ZD_ZZB set ...; 
tot := tot + sql%rowcount;

dbms_output.put_line('Total rows = '||tot);
end;
/