LOV with ORA-06502: character string buffer too small
meyekalNov 13 2009 — edited Dec 18 2009Hi 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