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?