Forum Stats

  • 3,759,958 Users
  • 2,251,621 Discussions
  • 7,870,883 Comments

Discussions

Interactive grid with 300 columns. getting ORA-06502: character string buffer too small

Hi All,

  • I have an interactive grid with more than 300 columns. Now I need to add logic using SQL Query for list of values for most of the columns, however after a limit I am unable to add logic. It gives error - ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 992 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1212 ORA-06512: at "APEX_190200.WWV_FLOW_DISP_PAGE_PLUGS", line 1930 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4261 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3460 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 1385 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 1577 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2426 ORA-06512: at "APEX_190200.WWV_FLOW_EXEC", line 2171 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 3448 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 4083 ORA-06512: at "APEX_190200.WWV_FLOW_INTERACTIVE_GRID", line 5928 ORA-06512: at 

Any idea how additional logic can be incorporated. I have already tried using PLSQL Function body to return query but that also does not work.

Thanks,

Akanksha

Tagged: