We are using APEX 5.1.4 and have an Interactive Grid that has 85 columns. These columns are not all displayed all the time and are conditionally displayed depending on which "tab" the user presses.
We have an issue that when the user does a free text search, using the standard search box provided by IG, that we get the following error,
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
I have found a couple of hits which suggest that this is due to the number of columns? Is there a way to restrict the columns that the search applies to?
eg. If I have columns
to say that I only want the free text search to search Name and Job title, and not address?
Any suggestions gratefully received.