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!

APEX_APPLICATION.G_F01.. G_F50.. assigning sequence dynamically

DeepakJMay 14 2013 — edited Jul 2 2013
Hi,

Can we generate F01 .. F50 numbers as mentioned below.
  declare
     v_seq number := 10;
     v1 varchar2(100);
  begin
    
     for i in 1..apex_application.g_f01.count
     LOOP
      v_seq :=  v_seq + 1;  -- v_seq will have value 11,12,13,..

      v1 := apex_application.g_f||v_seq||(i); -- CAN I DO LIKE THIS, I tried but getting error.

    END LOOP;

 
so v_seq will have value with 11, 12, 13 each time and then I want to assign the following to v1

apex_application.g_f11(i)
apex_application.g_f12(i)
apex_application.g_f13(i)
apex_application.g_f14(i)


So can I refer apex variables like above [G_F11, G_F12, GF13, ....]

----
Thanks,
Deepak
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2013
Added on May 14 2013
3 comments
835 views