declare
   eda_id number;
   eda_name varchar2(255);
   eda_price number;
begin
   if apex_collection.collection_exists('MYTOVAR')=false then
   apex_collection.create_collection('MYTOVAR');
   end if;
for i in1..apex_application.g_f01.count loop
   select EDA_ID, NAME, PRICE into eda_id, eda_name, eda_price from P_EDA where EDA_ID=apex_application.g_f01(i);
   apex_collection.add_member('MYTOVAR', eda_id, eda_name, eda_price);
enb loop;
end;

select seq_id, c001, c002, c003
from apex_collections
where collection_name='MYTOVAR'

declare
   zakaz_list number;
   summa number;
   col1 number;             /* id товара */
   col2 varchar2(255); /* название товара */
   col3 number;             /* цена товара */
begin
summa:=0;
select (c001, c002, c003) into (col1, col2, col3) from apex_collections where collection_name='MYTOVAR';
   update P_STOL
   set ZAKAZ_ID = :P8_HIDE_ZAKAZ
   where STOL_ID = :P8_HIDE_STOL;
       update P_STOL
       set SVOBODA = 0
       where STOL_ID = :P8_HIDE_STOL;
for i in 1..apex_application.g_f01.count loop
   summa:=summa + col3;
   select "P_ZAKAZ_INFO_SEQ".nextval into zakaz_list from sys.dual;
      insert into P_ZAKAZ_INFO(ZAKAZ_INFO_ID,ZAKAZ_ID,EDA_ID,EDA_NAME,EDA_PRICE)
      VALUES(zakaz_list, :P8_HIDE_ZAKAZ,col1,col2,col3);
end loop;
update P_ZAKAZ
set SUMMA = summa
where ZAKAZ_ID = :P8_HIDE_ZAKAZ;
end;