Oh, ok.
Then I'll trie, to implement it into my code.
I meant a variable in a PL/SQL block.
Currently I'm doing it this way, because it was the only way I got running:
case
when x = 1 then v_var := apex_application.g_f04(i);
when x = 2 then v_var := apex_application.g_f06(i);
when x = 3 then v_var := apex_application.g_f08(i);
when x = 4 then v_var := apex_application.g_f10(i);
when x = 5 then v_var := apex_application.g_f12(i);
when x = 6 then v_var := apex_application.g_f14(i);
when x = 7 then v_var := apex_application.g_f16(i);
when x = 8 then v_var := apex_application.g_f18(i);
when x = 9 then v_var := apex_application.g_f20(i);
when x = 10 then v_var := apex_application.g_f22(i);
when x = 11 then v_var := apex_application.g_f24(i);
when x = 12 then v_var := apex_application.g_f26(i);
when x = 13 then v_var := apex_application.g_f28(i);
when x = 14 then v_var := apex_application.g_f30(i);
when x = 15 then v_var := apex_application.g_f32(i);
when x = 16 then v_var := apex_application.g_f34(i);
else null;
end case;
Where x and i are control variables.
My problem is, that it also might look like this "when x = 3 then v_var := apex_application.g_f07(i)" or "when x = 3 then v_var := apex_application.g_f06(i)".
That's why I'd like do get g_fxx dynamically
Edited by: DFiles on 07.01.2011 10:27