Skip to Main Content

Interactive grid: restricting columns that are searched

Jeremy WebbMay 10 2018 — edited May 10 2018

Hi,

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

NAME
ADDRESS
JOB_TITLE

to say that I only want the free text search to search Name and Job title, and not address?

Any suggestions gratefully received.

Thanks,

Jeremy

Comments
Post Details
Added on May 10 2018
5 comments
102 views