Oracle 如何记录DML操作影响条数

create table emp_test as select * from emp;
drop table emp_test;

--创建存储过程, 用隐式游标记录影响条数SQL%ROWCOUNT
create or replace procedure a(aa out number)  as
       i_num number; --insert
       d_num number; --delete
       u_num number; --update
       
begin
      update emp_test set job ='SALESMAN' where job != 'SALESMAN';
      u_num := to_number(SQL%ROWCOUNT);
       
      insert into emp_test select * from emp where ename='KING';
      z_num := to_number(SQL%ROWCOUNT);
       
      delete from emp_test where ename = 'SMITH';
      s_num := to_number(SQL%ROWCOUNT);
      commit;
      
      aa := u_num + z_num +s_num;
end;

--调用存储过程
declare
      para number;
begin
      a(para);
      dbms_output.put_line(para);
end;

--带输出参数的存储过程, 调用时候也需要申明一个para去接收
--para传参给a存储过程, a返回一个结果给para, para此时就是可以被调用的结果