How to assign variable with dynamic page item?
648421Jan 6 2011 — edited Jan 10 2011Hi there,
I'm facing following problem:
I need to assign a variable with a value of a page item - e.g. apex_application.g_f04(i).
My problem is, that f04 might be everthing between f04 and f52 (or whatelse was max. number of page items?).
I tried several things, among others something like this:
v_test := apex_application.g_f || x || ( i) /* where x might be another variable */
or
v_stat := 'SELECT apex_application.g_f' || x || '( i) from DUAL'
EXECUTE IMMEDIATE v_stat INTO v_test
but I didn't get it till now...
Any ideas?
Edited by: DFiles on 06.01.2011 13:57