APEX

Hi ALL,

So here is my issue. I have a Tabular form with ~10 coulumns. I would like 5 of those colums to be the SAME Select list (named LOV). The LOV is basiclly a select against a field in a different table.

I can make 4 of these columns the named LOV without issue. Once I turn the 5th column to a named LOV I get the error

report error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The error is not dependent on a column. If I change which columns have the named LOV, it does not give the error as long as there are only 4 of them. Once I use a 5th column, I get the error.

Looking around on the forum, I saw some mention of a 32K limit. So is this a limit for all LOV added up for a row or page? I am trying to get a bit more information so I can figure out what my options are

It does seem like I can use the popup LOV to work around this (which has been suggested in other threads), but the Select list LOV just looks much better. Can anyone think of any other options?

Thanks