if the query where my resource gantt chart is based on returns more the 107 rows, i will get the following error:
chart Flash Chart error: ORA-20001: Print Chart Data: Flash Chart error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
If i reduce the number of results, the chart is working fine.
Max rows attribute of the series is adjusted to 4000
You may be hitting the 32k limit for the chart XML being generated for the Gantt chart. Based upon the error you've reported, it sounds like that's the case. To work around this issue, your best option is to create your own custom Gantt chart, which will require the generation of the chart XML in the format expected by AnyChart. If you search on the forum, you'll find a number of related posted (e.g. https://forums.oracle.com/forums/search.jspa?threadID=&q=32k+gantt&objID=f137&dateRange=all&userID=&numResults=15&rankBy=10001). We certainly hope to address the 32k limit in a future release, but in the meantime, the generation of a custom Gantt chart is your best bet. While it's not a gantt example, I've added a map example to my sample application (http://apex.oracle.com/pls/apex/f?p=36648:109), demonstrating one possible method of generating a custom chart via a PL/SQL region and associated PL/SQL function for handling the generation of the XML. It could certainly be modified to work for a Gantt chart.
ok figured out that i have to use ganttchart_4 not anychart_6...
it works, but again only for a subset of data.
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_LOB", line 1064
ORA-06512: at line 21
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
ORA-06512: at "SYS.WWV_DBMS_SQL", line 1064
ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 4613
ORA-06512: at "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", line 3220