Using APEX 18 I have a shuttle item (P19_HOSTS), which I am using as variable for my (line) chart query:
select ITEM, ACTION, TARGET
from ITEMS_VIEW
where instr(':'||:P19_HOSTS||':',':'||TARGET||':') > 0
The "hosts" list in the shuttle is generated dynamically. The length of P19_HOSTS could be up to 10000 chars (when all hosts are selected).
The problem is that when P19_HOSTS is greater than 4000 chars, I get error:
Ajax call returned server error ORA-01460: unimplemented or unreasonable conversion requested for
Searching thru documentation and blogs I find references to earlier Bugs (5872943), but these should all be fixed.
Questions:
Is 4000 chars the limit for the result length of an APEX shuttle item ? Can this be changed ?
How can I workaround this ?
Thanks for any pointers.