This discussion is archived
8 Replies Latest reply: Jan 13, 2013 4:51 PM by Vite DBA RSS

character string buffer too small error in tabular form

William Wallace Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points