Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LOV with ORA-06502: character string buffer too small

meyekalNov 13 2009 — edited Dec 18 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2010
Added on Nov 13 2009
14 comments
1,824 views