In my interactive report. Using the search field. First search works, but tagging on to the search results in the widget failure error. For example, search AR-TEST all records with AR-TEST display. add another search to the first for example, BASIL, and the error is thrown.
{"dialog":{"uv":true,"row":[{"V":"Widget Failure
ORA-06502: PL/SQL: numeric or value error: character string buffer too small,
worksheet"}]}}
After leaving this report page and getting back in I get the character string buffer too small error without the widget prefix:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
So it seems to me it's something to do with what Apex is doing when concatenating the search??
Thanks in advance.
Alex
Application Express 4.2.2.00.11