oracle存储过程 更新表的排序

create or replace procedure update_res_cloumn_map  is
begin
 for res_cloumn_map_rec in (select distinct m.column_id from t_res_cloumn_map  m)
 loop
   --更新数据
 begin
  for rec in (select rowid, rownum
                from tianweim.T_RES_CLOUMN_MAP m
               where m.column_id = res_cloumn_map_rec.column_id
               order by m.resource_rank, m.resource_id) loop
    update tianweim.T_RES_CLOUMN_MAP t
       set t.resource_rank = rec.rownum
     where rowid = rec.rowid;
  end loop;
  commit;
end;
end loop;
end update_res_cloumn_map;
/