This content has been marked as final. Show 4 replies
i have almost solved the issue myself but still having an issue.
i have created cursor and collection type then usiing for loop and all working ok but i am not getting session state as i am doiing as follows.
v_desc := APEX_UTIL.GET_SESSION_STATE(':p30_ques(i)'); -- p.s :p30_ques(i) has both char and numeric value. say. :p30_ques1 (y/n), :p30_ques2 ('AA' or ZZ')
:p30_ques3 ('ahhaa'), :p30_ques4('asdasja')
in my table all first 3 cols are pouplated but last col (desc) not.
any reason. please help?
Its really hard to understand what exactly you are asking for.
Can you be please clear, so that I can try to help you out.
it's been solved. thx for help!
Actually I was looking current session item value in my process for data insert.
i have been used as v_desc := v('p30_ques'||rec(i).my_code); and its working ok.
i was doing wrongly as v_desc := v(':p30_ques.rec(i).my_code');