I've built a dashboard with some pie charts. I also got to implement a drill down based on what region of a chart you select.
I set the following in Chart/Attributes/Link/Target (setting link Type: Redirect to URL)
Type: URL
URL: javascript:clickChart_1_6_7_8("#ID_POLIZAS#")
Of course ID_POLIZAS is a column name from data selected in the chart query. This field can be really long, it is selected as a CLOB value in the query.
But it looks like Oracle Apex doesn't allow to set that large URLs. It's throwing an ORA-06502 on runtime:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Other charts are working properly, it only happens on charts with a lot of data on ID_POLIZAS column.
Is there a way to pass that kind of value to a javascript function when clicking on a chart region?