Oracle 存储过程删除大表记录

create or replace procedure whxd
as
begin
loop
delete from sj where t exit when SQL%ROWCOUNT=0;
commit;
end loop;
exception
when others then
rollback;
return;
end;