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!

Working with APEX_APPLICATION.GFXX

550387Jan 16 2007 — edited Jan 17 2007
Hello,
I have created a series of checkboxes on my page. When the page is submitted I loop through the apex_application.GF01 array to see which of check boxes has been set.

------
FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
update mytable set status = 'CHECKED' where my_id = to_number(APEX_APPLICATION.G_F01(i));

END LOOP;
-----
I would like to be able to also update the table based on what is not on the list, so would like to do something like this;

------
update mytable set status='UNCHECKED' where my_id not in ( select <INSERT ALL VALUES FROM ARRAY> from dual);
------

Can somebody please guide me on how to select out of this array... do I just need to create another type and select out of that, or is there a simple way that I am unaware of.

Thanks
Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2007
Added on Jan 16 2007
2 comments
649 views