oracle存储过程2

随机拿几个食品,食品的总和等于某个价格
create table test1234 ( id number);
insert into test1234 values(10);
insert into test1234 values(20);
insert into test1234 values(30);
insert into test1234 values(40);
insert into test1234 values(50);
  
create or replace procedure fun_id(v in number, v_ex_id in number)
is
  
v_flag number := 0;
   v_id number := 0;
  
v_rest number := 0;
begin
   select count(1) into v_flag from test1234 where id = v;
   if v_flag > 0 then
      select id into v_id from test1234 where id = v;
      dbms_output.put_line(v_id);
   else
      select count(1) into v_flag from test1234 where id < v and id not in (v_ex_id);
      if v_flag > 0 then
         select id into v_id from
         (select * from test1234 where id < v and id not in (v_ex_id) order by dbms_random.value)
         where rownum <= 1;
         dbms_output.put_line(v_id);
         v_rest := v - v_id;
         fun_id(v_rest,v_id);
      else
         dbms_output.put_line('No record found');
      end if;
   end if;
end fun_id;
/
execute fun_id(70, 0);