Hi - I have a query which returns columns TARGET, TARGET_DATE, TARGET_COUNT.
In my multi-series line chart I try to show TARGET_COUNT per TARGET_DATE and I am using TARGET_NAME as the series:
This is giving me an error “Ajax call returned server error ORA-06502: PL/SQL: numeric or value error: character string buffer too small for”.
I suspect this is because the number of series (distinct TARGETs) is too large.
Since I am only interested in the top 10 TARGETS by TARGET_COUNT I was thinking to “rank” the TARGETS.
However, the line chart should have "Zoom and Scroll" enabled, so I would need to do this dynamically since the top 10 TARGETs by TARGET_COUNT would change for each TARGET_DATE, and respectively for each TARGET_DATE range.
Ranking on the top 1o TARGETS overall would miss data when I zoom into the dynamic chart. (e.g. if top 10 TARGETS had low counts during my zoomed-in date).
Questions:
- Is there a way for a multi-series line chart to dynamically display the top x series for a given (zoomed-in) date range ?
- What is the limit of series for a multi-series line chart, and can this limit be increased ?
- Any other idea for above ORA-06502, if it's not caused by the series limit ?
Thanks for any pointers. -alex