Hi Folks,
One of my tabular forms suddenly stopped working out of the blue after 3 months of working perfectly. So I've run into the debug and looks like something went wrong rendering my LOV as below:
0.16968 0.00328 ...Execute Statement: begin begin SELECT TIME_DISPLAY D, TIME_RETURN R bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value FROM TS_HOURS ORDER BY 2; end; end; 4
8
0.17292 0.03912 ...Execute Statement: begin begin select /*+ cardinality(t 10) */ disp, val bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value from table(wwv_flow_utilities.get_temp_lov_data(2)) t order by insert_order, disp; end; end; 4
100
0.21211 0.00224 report error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
I've looked around and saw few others having same issues but nothing that's like mine. Could someone please help me find what the issue is? THanks.
I am using Apex 4.1.1