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!

FOR i in 1 .. APEX_APPLICATION.G_F01.COUNT LOOP QUERY

ReemaPuriJun 25 2015 — edited Jul 3 2015

  i am using

APEX_ITEM.CHECKBOX2(

        p_idx                       =>    1,

        p_value                     =>    ROWNUM,

        p_attributes                =>   'UNCHECKED',

        p_checked_values            =>    NULL,

        p_checked_values_delimiter  =>    ':',

        p_item_id                   =>    'f01_#ROWNUM#',

        p_item_label                =>    'Label for f01_#ROWNUM#') "Select"

suppose there are ten checkboc on one page

In Plsql process when i use

-----------------------------------------------------------------------------------------

FOR i in 1 .. APEX_APPLICATION.G_F01.COUNT LOOP

when i click on 5th checkbox

declare

begin

insert into tablename values(APEX_APPLICATION.G_F01(i);

end;

and use insert process itakes i=1

----------------------------------------------------------------------------------------------------------

when i use

declare

c=APEX_APPLICATION.G_F01(i);

raise_application_error(-20001, c);

and use

begin

insert into tablename values(APEX_APPLICATION.G_F01(c);

end;

then it gives no data found for rest of the checkboxes unchecked  and c=5;

This post has been answered by ReemaPuri on Jun 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2015
Added on Jun 25 2015
2 comments
2,832 views