[Griboed0ff]

Оказалось все просто:

Код:

drop table qqqqqqq;
create global temporary table qqqqqqq
( ncount number,
  rerror varchar (1000))
  on commit delete rows; 
DECLARE 
rrrr  rta.list.request_id%TYPE;
begin    
   dbms_output.enable (buffer_size => NULL);  
  FOR jj IN (select distinct result_detail from rta.list where system_date>='16.02.2022' and operation_error='ERROR')
  loop 
      select count(result_detail) into rrrr from rta.list where result_detail=jj.result_detail and system_date>='16.02.2022';
      Insert into qqqqqqq(ncount,rerror) values (rrrr,jj.result_detail);
      --dbms_output.put_line(rrrr||'::::'||jj.result_detail);
   end loop;
end;
/
select * from qqqqqqq;

Почему-то нигде не написано, что нужен слеш между end и следующей командой.