https://apex.oracle.com/pls/apex/f?p=134181:48
IG query is
select
seq_id seq_id,
c001 c001,
c002 c002
from apex_collections
where collection_name = 'IG'
SEQ_ID: Display Only, Primary Key = Yes, Query Only = No
IG Save uses custom PL/SQL code
if (not (apex_collection.collection_exists('IG')))
then apex_collection.create_collection('IG');
end if;
case :apex$row_status
when 'C' then
apex_collection.add_member(
p_collection_name => 'IG',
p_c001 => :C001,
p_c002 => :C002
);
when 'U' then
apex_collection.update_member(
p_collection_name => 'IG',
p_seq => :SEQ_ID,
p_c001 => :C001,
p_c002 => :C002
);
when 'D' then
apex_collection.delete_member(
p_collection_name => 'IG',
p_seq => :SEQ_ID
);
end case;
I am seeing behavior I can't explain.
- Click Add Row
- Enter values for C001 and C002
- Click Save
- Change are saved successfully but the IG does't refresh to show the newly added row.
- Click Go and now the new row shows up fine
Any ideas?