Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive grid - Edit collection

partlycloudyNov 12 2018 — edited Nov 12 2018

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.

  1. Click Add Row
  2. Enter values for C001 and C002
  3. Click Save
  4. Change are saved successfully but the IG does't refresh to show the newly added row.
  5. Click Go and now the new row shows up fine

Any ideas?

This post has been answered by Pierre Yotti on Nov 12 2018
Jump to Answer
Comments
Post Details
Added on Nov 12 2018
4 comments
1,848 views